How to get the design of a table...using command

Question

How to get the design of a table...using command

forsqlserver

SSCoach

Points: 18902
More actions
September 15, 2011 at 4:38 am

#257183

How to get the design of a table...What is the command?
Thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Ronald H SSCarpal Tunnel Points: 4053 More actions · Answer 1

sp_help 'Tablename' should do the work.

Ronald HensbergenHelp us, help yourself... Post data so we can read and use it: http://www.sqlservercentral.com/articles/Best+Practices/61537/-------------------------------------------------------------------------2+2=5 for significant large values of 2

forsqlserver SSCoach Points: 18902 More actions · Answer 2

forsqlserver

SSCoach

Points: 18902

September 15, 2011 at 7:04 am

#1381910

Can I get a create table statement for this?

Thanks

spaghettidba SSC Guru Points: 105732 More actions · Answer 3

This should do:

http://www.sqlservercentral.com/scripts/SQL+Server+2005/67515/

-- Gianluca Sartori