Database Reference
In-Depth Information
Figure 5-21.
Setting a composite primary key constraint
Once you have designed the table to your satisfaction, save your work by using the File menu and choosing
the Save Table option. You can also click the button on the toolbar that looks like a floppy disk (Figure
5-21
).
Upon saving, you will be prompted for a table name, unless if you have configured a new name in the Properties
window already (Figure
5-20
).
Generating SQL Scripts
The SQL Server Management Studio's designer tool invisibly creates SQL code for you each time you create or
modify a table. You can access this code by using the Generate Change Script menu option, as shown in Figure
5-22
.
Figure 5-22.
Generating a change script
