Computer Science
Which of the following is not a legal constraint for a CREATE TABLE command ?
- Primary key
- Foreign key
- Unique
- Distinct
DDL & DML
3 Likes
Answer
Distinct
Reason — The legal constraints for a CREATE TABLE command include the Primary key constraint, Foreign key constraint, Unique constraint, Check constraint, Default constraint. However, the Distinct is not a valid option for a CREATE TABLE command.
Answered By
1 Like
Related Questions
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
Which of the following is not a DDL command ?
- UPDATE
- TRUNCATE
- ALTER
- None of these
Fill in the blanks:
A database can be opened with _________ <database> command.
Fill in the blanks:
To list the names of existing database, you can use _________ command.