SQL Server 2012 Management Studio - scripts

Question

I installed Microsoft SQL Server Management Studio 11.0.3128 and you need to use the "script as" table to generate a drop and create a script for my tables. I have 107 tables in my database.

If I select all my tables, the generated generated foreign key script will be omitted and the pk and fk create scripts will be omitted. The exception of one of the tables (any) gives the expected result, including the fk and pk scripts in the generated SQL.

Thank.

Answer 1

1) Select a database

2) Right-click, select "Task" → "Generate Scripts"

3) "" > , , , SProc,

4) → , " -" " ". ""

5) , . " /" "" "", .