Home Forums SQL Server 2008 T-SQL (SS2K8) Is it possible to create a script that will generate a create table script for all tables in a database at once? RE: Is it possible to create a script that will generate a create table script for all tables in a database at once?

  • November 9, 2012 at 11:27 am

    #1557745

    In SSMS you can right click on the database and use Tasks-> Generate Scripts...

    That will give you plenty of options to generate the scripts for all or some of the objects of your database.

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2