StumbleUpon
Share on Facebook

Monday, January 11, 2010

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

1 comment:

Anonymous said...

nice post. thanks.

Related Posts Plugin for WordPress, Blogger...