View Table Structure Query - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

View Table Structure Query

Author

Topic

micnie_2020
Posting Yak Master

232 Posts

Posted - 2010-03-04 : 02:22:33

Dear All,

any one have sql statement to running at query analyzer for viewing the table structure like

Create Table
(
:
:)

Thank you.

Regards,
Micheale

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-03-04 : 02:38:33

To SEE information about table structure you can use sp_help table_name.
But this won't give you a create statement.

No, you're never too old to Yak'n'Roll if you're too young to die.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-03-04 : 02:41:33

You can use

EXEC sp_help table_name

or

try
http://beyondrelational.com/blogs/madhivanan/archive/2007/08/27/generate-sql-script.aspx

Madhivanan

Failing to plan is Planning to fail

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-03-04 : 02:42:14

Madhivanan

Failing to plan is Planning to fail

micnie_2020
Posting Yak Master

232 Posts

Posted - 2010-03-04 : 03:04:36

quote:
Originally posted by madhivanan

You can use

EXEC sp_help table_name

or

try
http://beyondrelational.com/blogs/madhivanan/archive/2007/08/27/generate-sql-script.aspx

Madhivanan

TQVM. Great! It's work Fine!!

Cheers,
Micheale

Failing to plan is Planning to fail

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-03-04 : 03:59:35

Does TQVM stand for Thank You Very Mcuh?

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources