How to get table structure using query?

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

How to get table structure using query?

Thanks,
Seen



Responses

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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
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

Up
0
Down
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

Login to post response