USE ; GO SELECT * FROM sys.tables; GO USE adventureWorks; SELECT SCHEMA_NAME(schema_id) AS schema_name , t.name AS table_name FROM sys.tables AS t ORDER BY schema_name, table_name; output: name object_id ... type type_desc create_date modify_date, is_ms_shipped TPerson 181575685 NULL 1 0 U USER_TABLE 2007-07-29 03:59:59.853 2007-07-29 04:24:13.433 0 0 0 0 NULL 13 0 1 0 0 0 0 0 0 0 TContact 277576027 NULL 1 0 U USER_TABLE 2007-07-29 04:26:46.290 2007-07-29 04:26:46.350 0 0 0 0 NULL 19 0 1 0 0 0 0 0 0 0 TSCUUserRole 373576369 NULL 1 0 U USER_TABLE 2007-07-29 04:37:12.153 2007-09-18 23:12:39.623 0 0 0 0 NULL 8 0 1 0 0 0 0 0 0 0 TSCURolePgm 437576597 NULL 1 0 U USER_TABLE 2007-07-29 04:52:10.563 2007-09-18 23:12:27.163 0 0 0 0 NULL 12 0 1 0 0 0 0 0 0 0 TSCUProgram 469576711 NULL 1 0 U USER_TABLE 2007-07-29 04:52:57.300 2007-09-18 23:12:11.183 0 0 0 0 NULL 14 0 1 0 0 0 0 0 0 0 TCounter 533576939 NULL 1 0 U USER_TABLE 2007-07-29 05:03:15.853 2007-07-29 05:03:15.857 0 0 0 0 NULL 12 0 1 0 0 0 0 0 0 0 TEvent 693577509 NULL 1 0 U USER_TABLE 2007-07-29 05:43:58.330 2007-07-29 05:43:58.347 0 0 0 0 NULL 17 0 1 0 0 0 0 0 0 0 TSCUUser 757577737 NULL 1 0 U USER_TABLE 2007-07-29 06:00:48.463 2007-09-18 23:12:33.720 0 0 0 0 NULL 15 0 1 0 0 0 0 0 0 0 TSCURole 821577965 NULL 1 0 U USER_TABLE 2007-07-29 06:02:42.180 2007-09-18 23:12:20.090 0 0 0 0 NULL 10 0 1 0 0 0 0 0 0 0 TCode 885578193 NULL 1 0 U USER_TABLE 2007-07-29 06:07:52.360 2007-09-18 23:23:24.873 0 0 0 0 NULL 12 0 1 0 0 0 0 0 0 0 TChatRoom 949578421 NULL 1 0 U USER_TABLE 2007-07-29 14:25:12.700 2007-07-29 14:25:12.743 0 0 0 0 NULL 7 0 1 0 0 0 0 0 0 0 TChatMsg 981578535 NULL 1 0 U USER_TABLE 2007-07-29 14:28:57.383 2007-07-29 14:28:57.387 0 0 0 0 NULL 10 0 1 0 0 0 0 0 0 0 TRTMTask 1013578649 NULL 1 0 U USER_TABLE 2007-07-29 14:29:41.813 2007-09-18 23:10:55.020 0 0 0 0 NULL 19 0 1 0 0 0 0 0 0 0 TChatUser 1093578934 NULL 1 0 U USER_TABLE 2007-07-29 14:49:26.447 2007-07-29 14:49:26.457 0 0 0 0 NULL 6 0 1 0 0 0 0 0 0 0 TChatRoomUser 1157579162 NULL 1 0 U USER_TABLE 2007-07-29 14:53:56.933 2007-07-29 14:53:56.960 0 0 0 0 NULL 6 0 1 0 0 0 0 0 0 0 TRTMTicket 1221579390 NULL 1 0 U USER_TABLE 2007-08-11 19:43:18.410 2007-09-18 23:10:09.727 0 0 0 0 NULL 15 0 1 0 0 0 0 0 0 0 TSCUEMailMember 1365579903 NULL 1 0 U USER_TABLE 2007-08-26 18:40:08.290 2007-09-18 23:12:03.473 0 0 0 0 NULL 11 0 1 0 0 0 0 0 0 0 TRTMLogin 1461580245 NULL 1 0 U USER_TABLE 2007-09-18 23:05:55.930 2007-09-18 23:29:12.367 0 0 0 0 NULL 12 0 1 0 0 0 0 0 0 0 TRTMSession 1509580416 NULL 1 0 U USER_TABLE 2007-09-18 23:31:16.757 2007-09-18 23:31:16.760 0 0 0 0 NULL 11 0 1 0 0 0 0 0 0 0 myTab 1605580758 NULL 1 0 U USER_TABLE 2007-09-22 14:56:30.117 2007-09-22 14:56:30.137 0 0 0 0 NULL 1 0 1 0 0 0 0 0 0 0 schema_name table_name dbo AWBuildVersion dbo DatabaseLog dbo ErrorLog HumanResources Department HumanResources Employee HumanResources EmployeeAddress HumanResources EmployeeDepartmentHistory HumanResources EmployeePayHistory HumanResources JobCandidate HumanResources Shift Person Address Person AddressType Person Contact Person ContactType Person CountryRegion Person StateProvince Production BillOfMaterials Production Culture Production Document Production Illustration Production Location Production Product Production ProductCategory Production ProductCostHistory Production ProductDescription Production ProductDocument Production ProductInventory Production ProductListPriceHistory Production ProductModel Production ProductModelIllustration Production ProductModelProductDescriptionCulture Production ProductPhoto Production ProductProductPhoto Production ProductReview Production ProductSubcategory Production ScrapReason Production TransactionHistory Production TransactionHistoryArchive Production UnitMeasure Production WorkOrder Production WorkOrderRouting Purchasing ProductVendor Purchasing PurchaseOrderDetail Purchasing PurchaseOrderHeader Purchasing ShipMethod Purchasing Vendor Purchasing VendorAddress Purchasing VendorContact Sales ContactCreditCard Sales CountryRegionCurrency Sales CreditCard Sales Currency Sales CurrencyRate Sales Customer Sales CustomerAddress Sales Individual Sales SalesOrderDetail Sales SalesOrderHeader Sales SalesOrderHeaderSalesReason Sales SalesPerson Sales SalesPersonQuotaHistory Sales SalesReason Sales SalesTaxRate Sales SalesTerritory Sales SalesTerritoryHistory Sales ShoppingCartItem Sales SpecialOffer Sales SpecialOfferProduct Sales Store Sales StoreContact