Generate create table SQL script for all tables in database

Question

I need to create the SQL code that in it's output will return the CREATE TABLE SQL for all tables in current database.

Any suggestions?

Solution 1

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.

Solution 2

Use a Visual Studio SQL Server Database Project as follows:

1. Create a Visual Studio SQL Server Database Project.

2. From the Project Menu, select Import > Database ...

3. Right click on the project and click publish.