SQLServerCentral / 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? / Latest PostsInstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 02:23:44 GMT20RE: Is it possible to create a script that will generate a create table script for all tables in a database at once?http://www.sqlservercentral.com/Forums/Topic1383156-392-1.aspxYou can use the Genereate Scripts option as shown in the following link: [url=http://blog.sqlauthority.com/2011/05/07/sql-server-2008-2008-r2-create-script-to-copy-database-schema-and-all-the-objects-data-schema-stored-procedure-functions-triggers-tables-views-constraints-and-all-other-database-objects/][b]Generating Scripts in sql server[/b][/url]Mon, 12 Nov 2012 02:22:33 GMTvinu512RE: Is it possible to create a script that will generate a create table script for all tables in a database at once?http://www.sqlservercentral.com/Forums/Topic1383156-392-1.aspxIn 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.Fri, 09 Nov 2012 11:27:15 GMTLuis CazaresRE: Is it possible to create a script that will generate a create table script for all tables in a database at once?http://www.sqlservercentral.com/Forums/Topic1383156-392-1.aspxI ended up using the Transfer SQL Server Objects task in ssis to copy the tables over without the data which is exactly what I needed.Fri, 09 Nov 2012 11:24:18 GMTdndaughteryIs it possible to create a script that will generate a create table script for all tables in a database at once?http://www.sqlservercentral.com/Forums/Topic1383156-392-1.aspxSay I have a database called MyDB with 100 tables. I need to create these tables on another db. Is there a TSQL script that will return the create table scripts for all tables on MyDB?Fri, 09 Nov 2012 11:09:31 GMTdndaughtery