Get a schema of a database table listed out in SQL Server

From SQL Management Studio, select the table you want to generate schema, right click and select “Script table as…”, then “CREATE to”, then “New query window”

The management studio will generate a create statement to recreate the table, copy the code for your purpose.

Leave a Reply

Your email address will not be published. Required fields are marked *