Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- MB Database Tables 6/23/2011
- SELECT name FROM sys.Tables
- Output:
- Array
- (
- [0] => Array
- (
- [name] => Suppliers
- )
- [1] => Array
- (
- [name] => tblPromotion
- )
- [2] => Array
- (
- [name] => tblEFTSchedule
- )
- [3] => Array
- (
- [name] => tblAutoEmail
- )
- [4] => Array
- (
- [name] => tblClassLevels
- )
- [5] => Array
- (
- [name] => tblClientMembershipReferralDiscounts
- )
- [6] => Array
- (
- [name] => tblPromotionCategory
- )
- [7] => Array
- (
- [name] => tblClientRewards
- )
- [8] => Array
- (
- [name] => tblPromotionProduct
- )
- [9] => Array
- (
- [name] => tblClassPrereq
- )
- [10] => Array
- (
- [name] => tblPromotionSupplier
- )
- [11] => Array
- (
- [name] => tblPromotionTypeGroup
- )
- [12] => Array
- (
- [name] => BakDelCancelGrp
- )
- [13] => Array
- (
- [name] => tblClassProductGroups
- )
- [14] => Array
- (
- [name] => tblProspectStage
- )
- [15] => Array
- (
- [name] => tblTypeGroup
- )
- [16] => Array
- (
- [name] => tblClientRewardsRedeem
- )
- [17] => Array
- (
- [name] => Payment Types
- )
- [18] => Array
- (
- [name] => tblClassSch
- )
- [19] => Array
- (
- [name] => tblRegistry
- )
- [20] => Array
- (
- [name] => BakDelVisits
- )
- [21] => Array
- (
- [name] => tblClientRewardsRedeemBugFix4956
- )
- [22] => Array
- (
- [name] => tblClientStatusLog
- )
- [23] => Array
- (
- [name] => Returns
- )
- [24] => Array
- (
- [name] => VISIT DATA
- )
- [25] => Array
- (
- [name] => tblClientTag
- )
- [26] => Array
- (
- [name] => tblClosedData
- )
- [27] => Array
- (
- [name] => tblAggregateAppointments
- )
- [28] => Array
- (
- [name] => tblTrainerVisitRates
- )
- [29] => Array
- (
- [name] => Sales
- )
- [30] => Array
- (
- [name] => tblTravelInfo
- )
- [31] => Array
- (
- [name] => tblTypeGroupMembership
- )
- [32] => Array
- (
- [name] => tblClosedExpense
- )
- [33] => Array
- (
- [name] => Sizes
- )
- [34] => Array
- (
- [name] => tblAggregateAWhere
- )
- [35] => Array
- (
- [name] => tblTypeGroupTab
- )
- [36] => Array
- (
- [name] => tblContract
- )
- [37] => Array
- (
- [name] => Sales Details
- )
- [38] => Array
- (
- [name] => tblRoomNumbers
- )
- [39] => Array
- (
- [name] => tblAggregateClasses
- )
- [40] => Array
- (
- [name] => tblTypesClasses
- )
- [41] => Array
- (
- [name] => tblClosedHoliday
- )
- [42] => Array
- (
- [name] => BakDelWaitList
- )
- [43] => Array
- (
- [name] => tblUserOptions
- )
- [44] => Array
- (
- [name] => tblSeriesType
- )
- [45] => Array
- (
- [name] => tblAutoEmailTypeGroup
- )
- [46] => Array
- (
- [name] => BakManualDelPaymentData
- )
- [47] => Array
- (
- [name] => tblVersion
- )
- [48] => Array
- (
- [name] => tblClosedSalesCategory
- )
- [49] => Array
- (
- [name] => tblRSSIDHistory
- )
- [50] => Array
- (
- [name] => tblBB
- )
- [51] => Array
- (
- [name] => tblRegVDLkUp
- )
- [52] => Array
- (
- [name] => tblAggregateKPIType
- )
- [53] => Array
- (
- [name] => tblRelationship
- )
- [54] => Array
- (
- [name] => tblVisitTypes
- )
- [55] => Array
- (
- [name] => tblWaitList
- )
- [56] => Array
- (
- [name] => tblSavedReport
- )
- [57] => Array
- (
- [name] => tblAggregateKPI
- )
- [58] => Array
- (
- [name] => tblClosedSalesPmtType
- )
- [59] => Array
- (
- [name] => tblAggregateSales
- )
- [60] => Array
- (
- [name] => tblRelate
- )
- [61] => Array
- (
- [name] => tblAggregateVisits
- )
- [62] => Array
- (
- [name] => tblClosedTrainerExpense
- )
- [63] => Array
- (
- [name] => Student Types
- )
- [64] => Array
- (
- [name] => tblServiceCosts
- )
- [65] => Array
- (
- [name] => tblClientContracts
- )
- [66] => Array
- (
- [name] => tblShipment
- )
- [67] => Array
- (
- [name] => tblReservation
- )
- [68] => Array
- (
- [name] => tblAlert
- )
- [69] => Array
- (
- [name] => tblCollapsible
- )
- [70] => Array
- (
- [name] => tmpInvTable1
- )
- [71] => Array
- (
- [name] => tmpInvTable2
- )
- [72] => Array
- (
- [name] => tmpVDTG
- )
- [73] => Array
- (
- [name] => tblConstantContactLists
- )
- [74] => Array
- (
- [name] => Studios
- )
- [75] => Array
- (
- [name] => tblShoppingCart
- )
- [76] => Array
- (
- [name] => tblPayments
- )
- [77] => Array
- (
- [name] => tblWrldStateProv
- )
- [78] => Array
- (
- [name] => BakManualDelSales
- )
- [79] => Array
- (
- [name] => tmpVDVT
- )
- [80] => Array
- (
- [name] => tblConstantContactLocations
- )
- [81] => Array
- (
- [name] => tblWrldCountries
- )
- [82] => Array
- (
- [name] => TYPE DETAILS
- )
- [83] => Array
- (
- [name] => tblContactLogs
- )
- [84] => Array
- (
- [name] => _tmpBug7328
- )
- [85] => Array
- (
- [name] => BakManualDelSalesDetails
- )
- [86] => Array
- (
- [name] => tblClientAccount
- )
- [87] => Array
- (
- [name] => tblAppearance
- )
- [88] => Array
- (
- [name] => tblBelt
- )
- [89] => Array
- (
- [name] => tblSDPayments
- )
- [90] => Array
- (
- [name] => bakPayments
- )
- [91] => Array
- (
- [name] => tblContactLogComments
- )
- [92] => Array
- (
- [name] => bakSDPayments
- )
- [93] => Array
- (
- [name] => tblDiscounts
- )
- [94] => Array
- (
- [name] => Categories
- )
- [95] => Array
- (
- [name] => tblContactLogSubTypes
- )
- [96] => Array
- (
- [name] => tblShoppingCartEnrollDate
- )
- [97] => Array
- (
- [name] => tblCashRegister
- )
- [98] => Array
- (
- [name] => tblStudios
- )
- [99] => Array
- (
- [name] => tblContactLogsContactSubTypes
- )
- [100] => Array
- (
- [name] => tblTabs
- )
- [101] => Array
- (
- [name] => tblCCBatches
- )
- [102] => Array
- (
- [name] => tblGiftDebitCard
- )
- [103] => Array
- (
- [name] => tblResources
- )
- [104] => Array
- (
- [name] => tblCCNumbers
- )
- [105] => Array
- (
- [name] => ClassTimes
- )
- [106] => Array
- (
- [name] => tblContactTypes
- )
- [107] => Array
- (
- [name] => tblGiftDebitCardData
- )
- [108] => Array
- (
- [name] => tblClientAccountSDPayment
- )
- [109] => Array
- (
- [name] => tblGoLiveCheckList
- )
- [110] => Array
- (
- [name] => tblContactLogsContactTypes
- )
- [111] => Array
- (
- [name] => tblCCOpts
- )
- [112] => Array
- (
- [name] => PRODUCTS
- )
- [113] => Array
- (
- [name] => tblContractItem
- )
- [114] => Array
- (
- [name] => tblResourceSchedules
- )
- [115] => Array
- (
- [name] => tblClientStatus
- )
- [116] => Array
- (
- [name] => tblHardware
- )
- [117] => Array
- (
- [name] => tblContractLocations
- )
- [118] => Array
- (
- [name] => tblLocationFiles
- )
- [119] => Array
- (
- [name] => tblTabTimes
- )
- [120] => Array
- (
- [name] => tblHotWords
- )
- [121] => Array
- (
- [name] => tblContractSeriesTypeSetting
- )
- [122] => Array
- (
- [name] => tblPageLocation
- )
- [123] => Array
- (
- [name] => CLIENTS
- )
- [124] => Array
- (
- [name] => tblContractTerminationCode
- )
- [125] => Array
- (
- [name] => tblTask
- )
- [126] => Array
- (
- [name] => tblIDRange
- )
- [127] => Array
- (
- [name] => tblApptOpts
- )
- [128] => Array
- (
- [name] => tblClientAlertPages
- )
- [129] => Array
- (
- [name] => tblInventoryAdj
- )
- [130] => Array
- (
- [name] => tblCourses
- )
- [131] => Array
- (
- [name] => tblClientAlerts
- )
- [132] => Array
- (
- [name] => tblResourceTypes
- )
- [133] => Array
- (
- [name] => tblTempPhysicalInventory
- )
- [134] => Array
- (
- [name] => tblOpenTickets
- )
- [135] => Array
- (
- [name] => tblResourceVisitType
- )
- [136] => Array
- (
- [name] => tblInvOnHand
- )
- [137] => Array
- (
- [name] => tblTerms
- )
- [138] => Array
- (
- [name] => tblClientAutoLogin
- )
- [139] => Array
- (
- [name] => tblCCTrans
- )
- [140] => Array
- (
- [name] => tblResvOpts
- )
- [141] => Array
- (
- [name] => tblConstantContact
- )
- [142] => Array
- (
- [name] => tblCSS
- )
- [143] => Array
- (
- [name] => tblClientBeltData
- )
- [144] => Array
- (
- [name] => tblInvTransfer
- )
- [145] => Array
- (
- [name] => tblTest
- )
- [146] => Array
- (
- [name] => tblClientContractItem
- )
- [147] => Array
- (
- [name] => tblContractSuspTypes
- )
- [148] => Array
- (
- [name] => tblIPs
- )
- [149] => Array
- (
- [name] => SubCategory
- )
- [150] => Array
- (
- [name] => tblTestClass
- )
- [151] => Array
- (
- [name] => tblClassDescriptions
- )
- [152] => Array
- (
- [name] => tblLiability
- )
- [153] => Array
- (
- [name] => tblLocalization
- )
- [154] => Array
- (
- [name] => tblEKey
- )
- [155] => Array
- (
- [name] => tblTestQuestionCategory
- )
- [156] => Array
- (
- [name] => tblFiscalYear
- )
- [157] => Array
- (
- [name] => tblClassClientType
- )
- [158] => Array
- (
- [name] => tblMailerLists
- )
- [159] => Array
- (
- [name] => tblClientContractSuspend
- )
- [160] => Array
- (
- [name] => tblFormulaNotes
- )
- [161] => Array
- (
- [name] => tblTestQuestion
- )
- [162] => Array
- (
- [name] => tblSemesters
- )
- [163] => Array
- (
- [name] => tblClientMembershipIcon
- )
- [164] => Array
- (
- [name] => tblGCLayout
- )
- [165] => Array
- (
- [name] => tblMailerLocations
- )
- [166] => Array
- (
- [name] => tblAccessPriv
- )
- [167] => Array
- (
- [name] => TRAINERS
- )
- [168] => Array
- (
- [name] => tblMedia
- )
- [169] => Array
- (
- [name] => tblGCMsg
- )
- [170] => Array
- (
- [name] => Colors
- )
- [171] => Array
- (
- [name] => tblMobileProvider
- )
- [172] => Array
- (
- [name] => tblGenOpts
- )
- [173] => Array
- (
- [name] => tblClientCustomTypes
- )
- [174] => Array
- (
- [name] => tblPayRates
- )
- [175] => Array
- (
- [name] => tblTestData
- )
- [176] => Array
- (
- [name] => tblClientCustomFields
- )
- [177] => Array
- (
- [name] => dyntblAvgRevContr
- )
- [178] => Array
- (
- [name] => tblPayrollExport
- )
- [179] => Array
- (
- [name] => EntryTimes
- )
- [180] => Array
- (
- [name] => tblPayscales
- )
- [181] => Array
- (
- [name] => tblTestSet
- )
- [182] => Array
- (
- [name] => tblClientCustomValues
- )
- [183] => Array
- (
- [name] => tblPictures
- )
- [184] => Array
- (
- [name] => tblTestYoYoStages
- )
- [185] => Array
- (
- [name] => tblClientFiles
- )
- [186] => Array
- (
- [name] => tblTGRelate
- )
- [187] => Array
- (
- [name] => Referrers
- )
- [188] => Array
- (
- [name] => INVENTORY
- )
- [189] => Array
- (
- [name] => tblPO
- )
- [190] => Array
- (
- [name] => tblTimeClockTask
- )
- [191] => Array
- (
- [name] => RequiredFields
- )
- [192] => Array
- (
- [name] => tblClientIndex
- )
- [193] => Array
- (
- [name] => tblPODetail
- )
- [194] => Array
- (
- [name] => Location
- )
- [195] => Array
- (
- [name] => tblTimeClock
- )
- [196] => Array
- (
- [name] => tblProductLocations
- )
- [197] => Array
- (
- [name] => tblProductResourceTypes
- )
- [198] => Array
- (
- [name] => tblProductRestrictedTimes
- )
- [199] => Array
- (
- [name] => tblTimeClockTaskRates
- )
- [200] => Array
- (
- [name] => tblTrainerSchedules
- )
- [201] => Array
- (
- [name] => tblClientIndexValue
- )
- [202] => Array
- (
- [name] => tblClasses
- )
- [203] => Array
- (
- [name] => tblClientIndexData
- )
- [204] => Array
- (
- [name] => tblProductSeriesTypeSetting
- )
- [205] => Array
- (
- [name] => _Bug5964
- )
- [206] => Array
- (
- [name] => _tmp_Bug_6514
- )
- [207] => Array
- (
- [name] => tblClientMembershipData
- )
- [208] => Array
- (
- [name] => PAYMENT DATA
- )
- [209] => Array
- (
- [name] => tblProductVisitTypes
- )
- [210] => Array
- (
- [name] => BakDelAppts
- )
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement