I need to create the SQL code that in its output will return the CREATE TABLE SQL for all tables in current database.
Any suggestions?
3
-
Is there an analog of MySQL's "SHOW CREATE TABLE" that you can use?SteJ– SteJ2015-09-16 11:52:41 +00:00Commented Sep 16, 2015 at 11:52
-
possible duplicate of Create SQL script that create database and tablesRahul Tripathi– Rahul Tripathi2015-09-16 11:55:06 +00:00Commented Sep 16, 2015 at 11:55
-
Hmmm - seems not -- see hereSteJ– SteJ2015-09-16 11:55:40 +00:00Commented Sep 16, 2015 at 11:55
Add a comment
|
2 Answers
In SQL Server Management Studio(SSMS)
Right click on the DB_NAME -> Select Task -> Select Generate Script.
Follow along the presented wizard and select all tables in that database to generate the scripts.
2 Comments
Joshua
This doesn't answer the OP question. They were looking for a SQL script to perform this action.
Joshua
@DaleK See my comment on your answer. Any others that come looking, the answer is at stackoverflow.com/questions/706664/…
Use a Visual Studio SQL Server Database Project as follows:
- Create a Visual Studio SQL Server Database Project.
From the Project Menu, select Import > Database ...
Right click on the project and click publish.
3 Comments
Jonas
Thank you for this answer. I really love the ability to create database projects from existing databases. You can even track changes between your prod/dev DBs. Totally underrated answer!
Joshua
This doesn't answer the OP question. They were looking for a SQL script to perform this action.
Joshua
@DaleK I think you misunderstood the question. The OP wanted a SQL script that would generate the create scripts. Anyone could use SSMS or Visual Studio, but that doesn't satisfy unattended scripting needs. The correct answer can be found at stackoverflow.com/questions/706664/…