LGSGEEK

 Profile Answers by LGSGEEK 

• Mar 29th, 2008

 

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

sivasangari_2006

 Profile Answers by sivasangari_2006 

• Jan 30th, 2009

 

use <database name>
sp_help

It displays all the tables created in that database

cybersavvy

 Profile Answers by cybersavvy 

• Feb 19th, 2009

 

To Display list of tables in the database:
SELECT * FROM INFROMATION_SCHEMA.TABLES WHERE TYPE='basetable'

To describe the structure of a particular table
SP_HELP table_name;