Hi All,
I am using SQl server studio management to create table.
How to set two attributes as a primary key: composite key. like ( proj_id, emp id) both as primary key.
How to specify the forign key constraint. using alter table
Please give me the example: don't syntax which msdn gives.
Thanks and Regards
Abdul M.G
Hi,
Look at this.
1CREATE TABLE Menu2(3 MenuIdint,4 Titlevarchar(50),5 Urlvarchar(256),6 ParentIdintNULL7)89ALTER TABLE MenuADD CONSTRAINT MenuIdPRIMARY KEY1011ALTER TABLE MenuADD CONSTRAINT ParentIdREFERENCES Menu(MenuId)sql
