Computer Science
Fill in the blank :
…………… command is used to remove primary key from a table in SQL.
- update
- remove
- alter
- drop
DDL & DML
1 Like
Answer
alter
Reason — To remove a primary key constraint from a table the ALTER command is used. The DROP clause of ALTER TABLE command is used with syntax ALTER TABLE <TABLENAME> DROP PRIMARY KEY ;.
Answered By
2 Likes
Related Questions
Which of the following commands will delete the table from MYSQL database ?
- DELETE TABLE
- DROP TABLE
- REMOVE TABLE
- ALTER TABLE
…………… defines rules regarding the values allowed in columns and is the standard mechanism for enforcing database integrity.
- Column
- Constraint
- Index
- Trigger
Which command defines its columns, integrity constraint in create table :
- Create table command
- Drop table command
- Alter table command
- All of these
Which command is used for removing a table and all its data from the database :
- Create table command
- Drop table command
- Alter table command
- All of these