The default and Foreign keys are lost when SQL scripts are generated by SQL Server.

The default and Foreign keys are lost when SQL scripts are generated by SQL Server.

When generating SQL scripts (SQL scripts), SQL server does not have default values and Foreign keys by default.

The specific solution is as follows:

1. Select "show all" in the "General" tab when generating the SQL script, and then select "write all object scripts ".

2. on the "options" tab, select all the table script options, including:
-Compile the index script
-Write a full-text index script
-Compile the trigger script
-Write the primary key, foreign key, default value, and check constraint script.

The generated SQL script includes the primary key, foreign key, default value, and check constraint script.