CREATE, ALTER, constraints

About this topic

Design tables with NOT NULL, UNIQUE, CHECK, DEFAULT.

Part of SQL & DBMS: 22 topics, 5 free.

More topics in this course

• What is a database? Tables, rows, columns
• SELECT and WHERE
• ORDER BY, LIMIT, DISTINCT, LIKE
• COUNT, SUM, AVG, MIN, MAX
• GROUP BY and HAVING