SQL for Data Definition

Advertisement Remove all ads



  • CREATE Database
  • Use database
  • Show database
  • Drop database
  • Show tables
  • CREATE Table
  • Describe Table
  • Drop Tables
  • ALTER Table
  1. Add primary key to a relation
  2. Add foreign key to a relation
  3. Add constraint UNIQUE to an existing attribute
  4. Add an attribute to an existing table
  5. Modify datatype of an attribute
  6. Modify constraint of an attribute
  7. Add default value to an attribute
  8. Remove an attribute
    ⇒ Remove primary key from the table
  • DROP Statement
If you would like to contribute notes or other learning material, please submit them using the button below.
Advertisement Remove all ads

View all notifications

      Forgot password?
View in app×