Home Forums SQL Server 2008 SQL Server 2008 Administration how to script out create table script of all tables in a database RE: how to script out create table script of all tables in a database

  • August 6, 2013 at 8:31 am

    #1638958

    You should be able to get all you need from these views:

    INFORMATION_SCHEMA.TABLES

    INFORMATION_SCHEMA.COLUMNS

    sys.schemas

    sys.tables

    sys.columns

    There may be other system tables or views that could be helpful. You just need to take the time to learn what's available in system views.


    Alvin Ramard
    Memphis PASS Chapter[/url]

    All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

    For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]