MSMVPS.COM
The Ultimate Destination for Blogs by Current and Former Microsoft Most Valuable Professionals.
Sign in
|
Help
Home
Blogs
Media
Groups
All Tags
»
SQL Server
»
table
»
enterprise manager
(
RSS
)
Browse Site by Tags
Showing related tags and posts accross the entire site.
columns
schema
structure
Different ways to know structure of a table
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...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
(Weblog)
by
Anonymous
on 02-28-2008
Filed under: sql server, table, schema, columns, enterprise manager, structure
Page 1 of 1 (1 items)
Copyright © is the original authors. Blog site is an independent site not sponsored by Microsoft. The Yoda blog server and the Brianna SQL server would like to thank www.ownwebnow.com and www.exchangedefender.com. They wouldn't be here and broadcasting without the generosity of Vlad Mazek and his companies.