CREATE TABLE
noun
say it: “kree-AYT TAY-bul” /kriˈeɪt ˈteɪbəl/
The SQL statement that makes a new table, with its columns, types and rules.
What is CREATE TABLE in a relational database?
CREATE TABLE — A statement that defines a new table, its columns, and its constraints.
CREATE TABLE customer (
customer_id INTEGER PRIMARY KEY,
email CHARACTER VARYING(255) NOT NULL,
status CHARACTER VARYING(20) DEFAULT 'active'
);
In a sentence
- “I used CREATE TABLE to make Members with an id, a name and a city.”
Level: Apprentice · More SQL terms at this level
Updated