Computer Science

Which of the following is not a legal constraint for a CREATE TABLE command ?

  1. Primary key
  2. Foreign key
  3. Unique
  4. Distinct

DDL & DML

1 Like

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

3 Likes


Related Questions