Browse by Tags

All Tags » sql server » table » schema (RSS)
Different ways to know structure of a table
Published 28 February 8 2:51 AM | SSQA.net
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'...
Filed under: , , , , ,