A list of various ways to get a list of tables in SQL Server (TSQL)
http://www.aspfaq.com/show.asp?id=2178

I like this one for some reason:

SELECT table_name, table_type FROM information_schema.tables;


 

tags: sqlserver, mssql

Related Scribbles:

SQL Server

---

ID: 705
Author:
leonard
Date Updated:
2011-01-17 19:05:31
Date Created:
2005-10-26 23:20:25

Edit

---

Comments?

 >> Leonard Chan's Homepage  >> Scribble Web  >> MySQL "Show Tables" Equivalent in MS SQL Server

leonard.lotus-land.ca is hosted by Perceptus Solutions Inc.