SQL DDL Commands: The CREATE Statement Explained

Create a Customer Table

Write a CREATE TABLE statement to create a Customers table with columns: CustomerID (primary key), Name (not null), Email (unique), and SignupDate.

Expected output: A valid CREATE TABLE statement defining the Customers table with specified columns and constraints.

Hint: Use appropriate data types and constraints for each column.

Add a Foreign Key

Create an Orders table with OrderID as primary key and CustomerID as a foreign key referencing Customers(CustomerID).

Expected output: A CREATE TABLE statement for Orders with a foreign key constraint on CustomerID.

Hint: Use FOREIGN KEY syntax to link tables.

The CREATE statement is used to define and create new database objects such as tables, views, indexes, and schemas.

Yes, but it is not recommended because a primary key uniquely identifies each record and helps maintain data integrity.

Common constraints include PRIMARY KEY, NOT NULL, UNIQUE, FOREIGN KEY, and CHECK constraints.