| |
GeekInterview.com > Tech FAQs > SQL Server
| Print | |
Question: To display list of tables in database
Answer: How to display list of tables from a particular database in MS-SQL
How to display description of that particular table? |
| March 03, 2008 15:01:08 |
#1 |
| LGSGEEK |
Member Since: March 2008 Total Comments: 3 |
RE: To display list of tables in database
|
Submit a query on the SYS.TABLES table to get all of the data about the tables in a specific database. Be sure to specify the database that you are targeting.
USE <database name> -- Specify your target database name (without the brackets) GO SELECT * FROM SYS.TABLES
GO |
| |
Back To Question | |
