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
        )

)