Informatics Practices
Rajat wants to delete a primary key constraint from the table. Select an appropriate command to do so.
- Create
- Alter
- Drop
- Delete
Relational Database
2 Likes
Answer
Alter
Reason — The ALTER TABLE command is used to delete a primary key constraint from the table.
Answered By
2 Likes
Related Questions
The SQL statements always end with …………… .
- ,
- :
- ;
- "
Shivam wants to see the table structure in MySQL. Select an appropriate command to help him.
- Use
- Show
- Desc
- Display
Rajveer wants to rename column in display result for his query. Select the appropriate query for the same:
- Select Ename, Salary*12 Annual Salary From Emp;
- Select Ename, Salary*12 Rename "Annual Salary" From Emp;
- Select Ename, Salary*12 Change "Annual Salary" From Emp;
- Select Ename, Salary*12 as "Annual Salary" From Emp;
The symbol Asterisk (*) in a select query retrieves …………… .
- All data from the table
- Data of primary key only
- NULL data
- None of these