StumbleUpon  Del.icio.us  Facebook  Reddit  Add to diigo  


Follow - Monx007
Article Time Stamp: 27 June 2009, 21:22:04 GMT+7

Microsoft SQL (MS SQL): Sample SQL Script To Create List Of Tables At Current Database



We can create a list of tables at current database using Information Schema. Here's the sample script to create the list of the tables. Before you run these script, you must use (activate) the database that you want to see the list of tables first.


SELECT TABLE_SCHEMA,TABLE_NAME, OBJECTPROPERTY(object_id(TABLE_NAME), N'IsUserTable') AS type
FROM INFORMATION_SCHEMA.TABLES



Article Source: Monx Digital Library

Copyrighted@ Monx Digital Library, otherwise stated
Use of our service is protected by our Terms of Use



 Back To Previous Page ...  



 

 

 

AQWorlds Banner