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

  • July 28, 2009 at 7:40 am

    #1031013

    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

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!