How do I add a surrogate key to a table?
Posted on 2011-09-22
I want to manintain the current Primary Key as below:
CONSTRAINT [PK_Time] PRIMARY KEY CLUSTERED
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
What is the script to add a surrogate key to this table?