Saturday, July 23, 2011

Assign Primary Key in SQL Server Management Studio


How to Create Primary Key in SQL Server Management Studio
  1. In Table Designer, click the row selector for the Database column you want to define as the primary key. If you want to select multiple columns, hold down the CTRL key while you click the row selectors for the other columns.
  2. Right-click the row selector for the column and select Set Primary Key. A primary key index, named "PK_" followed by the table name, is automatically created; you can find it on the Indexes/Keys dialog box.


Primary Key in SQL SERVERPrimary Key in SQL SERVER
Primary Key in SQL SERVER Primary Key Index

0 comments:

Post a Comment

Twitter Delicious Facebook Digg Stumbleupon Favorites More

 
Design by Deep's | Bloggerized by Deep - Deep's Templates | ElearSQL-Server