SQL Server 2016 database generates a script with data

Step: Right click on the corresponding database----task--build script Select the desired object in the popup session box, click Next, in the settings and scripting options, click the Advanced button () Select the schema and data click OK.

Reminder: If you add a trigger in the database, and change the tracking script, as well as the index, and data compression options, these items are not added to the generated script by default.

SQL Server 2016 database generates a script with data