SQL CREATE TABLE

The following command will create a table called rent_payments with 5 data columns, a primary key constraint on the id column, and a foreign key to the tenant table.

-- Works in PostgreSQL, MySQL, SQL Server, and Oracle CREATE TABLE rent_payments( id INT PRIMARY KEY, tenant_id INT, building_address VARCHAR(100), dollar_amount decimal(6, 2) NOT NULL, payment_date DATE, FOREIGN KEY (tenant_id) REFERENCES tenant(id);