Different ways to know structure of a table

Published 28 February 08 01:51 AM | Madhivanan 

You can use one of the following to know the structure of a table

1 Generate SQL Script option from Enterprise Manager/Management Studio

2 select * from information_schema.columns where table_name='table_name'

3 EXEC sp_help 'table_name'

4 EXEC sp_columns 'table_name'

5 In Query Analyser type the name of the table, highlight it and press Alt+F1

Comments

# SQL Server Transact-SQL (SSQA.net) : Different ways to know structure of a table said on February 28, 2008 4:50 AM:

PingBack from http://sqlserver-qa.net/blogs/t-sql/archive/2008/02/28/3661.aspx

# Other SQL Server Blogs around the Web said on February 28, 2008 4:54 AM:

You can use one of the following to know the structure of a table 1 Generate SQL Script option from Enterprise

# http://sqlserver-qa.net/blogs/t-sql/archive/2008/02/28/3661.aspx said on March 26, 2008 1:55 AM:

PingBack from http://frankthefrank.info/entry.php?id=kwws%3d22vtovhuyhu0td1qhw2eorjv2w0vto2dufklyh2533%3b23525%3b269941dvs%7b

Anonymous comments are disabled