How to get table structure using query?

Posted by Seenuvasan under Sql Server on 6/15/2011 | Points: 10 | Views : 43421 | Status : [Member] | Replies : 4

Hi

How to get table structure using query?

Thanks,
Seen

Reply | Reply with Attachment

Posted by: Lakn2 on: 6/15/2011 [Member] Starter | Points: 25

0	sp_help tablename Thanks&Regards LakshmiNarayana Nalluri. Seenuvasan, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Robin_ahuja2008 on: 6/15/2011 [Member] Starter | Points: 25

0	You can do by selecting the table Name like tblEmployee (by highlighting it) then pres ALT + F1 Regards, Robin Ahuja Seenuvasan, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Susanthampy on: 6/15/2011 [Member] [MVP] Bronze | Points: 25

0	Hi http://www.sqlrecipes.com/sql_questions_answers/how_get_table_structure_via_sql-92/ Regards, Susan Seenuvasan, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Sriramnandha on: 11/24/2011 [Member] Starter | Points: 25

0	Hi, exec sp_help 'TableName' select * from information_Schema.tables Srriam.R sriram Seenuvasan, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts