What option is suited for adding an identity column in a existing table index to make a non uniqe index a unique one
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- Pick the two statements that are true regarding Identity Columns. (Select 2)
- What is Identity Column?
- Which Index ensures uniqueness in a table?
- Which keyword must you add to your index definition in the CREATE INDEX statement to ensure that no duplica...
- You are preparing a new index on a table that has 1,500 rows. 10 rows are added to this table every day. Th...
- While creating a table Primary key is defined but not Primary Index, then this will be considered as Primar...
- While creating a table Primary key is defined but not Primary Index, then this will be considered as Primar...
- You are creating an index for an existing table. There is already a nonclustered index on the primary key. ...