Friday, March 19, 2010

Multiple Columns as Primary Key - SQL Server 2005

Steps to make multiple Columns of a table in SQL Server Management Studio

  1. Go to Table Design.
  2. Select a Column first to define it as Primary key.
  3. To select multiple columns, hold down the CTRL key while you click the other columns.
  4. Right-click the row selector for the column and select Set Primary Key.
  5. A primary key index, named "PK_" followed by the table name is automatically created.
Hope this helps you

Happy Coding

0 Comments:

blogger templates | Make Money Online