SQLServerCentral / Article Discussions / Discuss content posted by Lowell / Article Discussions by Author / T-SQL to Export Table Structure to a script / Latest Posts

RE: T-SQL to Export Table Structure to a script

Lowell — Tue, 28 Jul 2009 07:40:43 GMT

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 [url]http://www.sqlservercentral.com/Forums/Topic751784-566-1.aspx[/url]Get DDL for any SQL 2005 Table [url]http://www.sqlservercentral.com/Forums/Topic751783-566-1.aspx[/url]

RE: T-SQL to Export Table Structure to a script

adrishmallik — Mon, 23 Mar 2009 09:49:59 GMT

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...

T-SQL to Export Table Structure to a script

Lowell — Sat, 29 Sep 2007 18:45:55 GMT

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