Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

T-SQL to Export Table Structure to a script Expand / Collapse
Author
Message
Posted Saturday, September 29, 2007 6:45 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:03 PM
Points: 12,963, Visits: 32,512
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
Posted Monday, March 23, 2009 9:49 AM


Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, June 3, 2009 9:51 AM
Points: 1, Visits: 6
replying on such an old discussion looks odd, but i just can't hold my hands..
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
Posted Tuesday, July 28, 2009 7:40 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:03 PM
Points: 12,963, Visits: 32,512
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 »

Add to briefcase

Permissions Expand / Collapse