T-SQL to Export Table Structure to a script

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Lowell » T-SQL to Export Table Structure to a script

T-SQL to Export Table Structure to a script

Rate Topic

Display Mode

Topic Options

Author

Message

Lowell

Posted Saturday, September 29, 2007 6:45 PM

SSChampion

Group: General Forum Members
Last Login: Today @ 1:11 PM
Points: 11,605, Visits: 27,645

Comments posted to this topic are about the item T-SQL to Export Table Structure to a script

Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #404516

adrishmallik

Posted Monday, March 23, 2009 9:49 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, June 03, 2009 9:51 AM
Points: 1, Visits: 6

replying on such an old discussion looks odd, but i just can't hold my hands.. Wink

you missed the computed column definition and extended properties, isn't it?

though i haven't yet run ur sp, but going thru the code i couldn't find anything regarding those two things.
i too have tried my hand on dis a bit. only sp_help gives the computed type column, but it doesn't give the expression for the column; i.e. on which column it gets calculated etc.

let me know if you find anything...

Post #681583

Lowell

Posted Tuesday, July 28, 2009 7:40 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 1:11 PM
Points: 11,605, Visits: 27,645

adrish sorry about the late followup; the forum doesn't seem to notify the author for posts on content the way it does for forum threads.

since this version got created, I've greatly enhanced some other versions of it;
these versions are much faster, and include everything: collation, cacvlulated columns, defaults, check constraints, triggers, you name it.

take a look at these:
Get DDL for any SQL 2000 Table http://www.sqlservercentral.com/Forums/Topic751784-566-1.aspx
Get DDL for any SQL 2005 Table http://www.sqlservercentral.com/Forums/Topic751783-566-1.aspx

Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #760741

« Prev Topic | Next Topic »

Permissions