Friday, May 31, 2019
How do i create a new composite constraint for the existing clustered index
Hello,
I recently faced to one question.
If I have a primary key one table , Some days after my table grows increased my volume of data.
So I need to create on two columns of same primary key (clustered index)
Answer: Instead of create new table and creating composite index on two columns.
Drop the existing column clustered index and recreate. But for the new column it should be not null column.
I created as follows .It has given the warning message like it should not be maximum key length of 900 bytes.
I recently faced to one question.
If I have a primary key one table , Some days after my table grows increased my volume of data.
So I need to create on two columns of same primary key (clustered index)
Answer: Instead of create new table and creating composite index on two columns.
Drop the existing column clustered index and recreate. But for the new column it should be not null column.
I created as follows .It has given the warning message like it should not be maximum key length of 900 bytes.
Subscribe to:
Posts (Atom)