SQL Server Performance

Different ways to know structure of a table

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Feb 28, 2008.

  1. Anonymous New Member

    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...(<a href="http://sqlserver-qa.net/blogs/t-sql/archive/2008/02/28/3661.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=3661" width="1" height="1">

Share This Page