Home > SQL Server > Table data scripting with SQL management Studio

Table data scripting with SQL management Studio

2011/10/26

This hint is tested on Microsoft SQL Server 2008 R2.

Right clic on database -> Tasks->Generate scripts

Choose object (a Table) , clic Next (to “Set Scripting Options”)

Clic Advanced, In General section -> Types of data to script there is the choice of data, schema , both.


Do not set Scripting options before, otherwise when you choose the object the script data type is reset to schema only and clicking Next you got only the schema.

Advertisements
Categories: SQL Server
%d bloggers like this: