I am using SQL server 2005.
I have one existing index created on a table.
This UNIQUE NONCLUSTERED INDEX is defined on one column EID at present but i want to add one more column PID to this existing index.
How i can alter the below index? Any help is appreciated.
CREATE UNIQUE NONCLUSTERED INDEX [TBL1_IDX1] ON [dbo].[TBL1]
(
[EId] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF) ON [PRIMARY]