Question: Which of the following is the valid syntax for adding a PRIMARY KEY constraint to an existing table? a. ALTER TABLE tablename ADD CONSTRAINT PRIMARY
Which of the following is the valid syntax for adding a PRIMARY KEY constraint to an existing table?
a. ALTER TABLE tablename ADD CONSTRAINT PRIMARY KEY (columnname);
b. ALTER TABLE tablename ADD CONSTRAINT (columnname) PRIMARY KEY constraintname;
c. ALTER TABLE tablename ADD [CONSTRAINT constraintname] PRIMARY KEY;
d. None of the above is valid syntax.
Step by Step Solution
3.37 Rating (153 Votes )
There are 3 Steps involved in it
d None ... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (2 attachments)
1803_60b8c12122bb3_716096.pdf
180 KBs PDF File
1803_60b8c12122bb3_716096.docx
120 KBs Word File
