SQL CREATE TABLE Statement

[sandoukhan]

After you create a database using the CREATE Database statement, you can now create a table. Table is where you store your data in your database.

SQL CREATE TABLE Syntax

1. CREATE
   
   TABLE
   
   TABLE_NAME
   
2. (
   
3. column_name1 data_type,
   
4. column_name2 data_type,
   
5. column_name3 data_type,
   
6. ....
   
7. )
   

Example # 1

1. CREATE
   
   TABLE
   
   Users
   
2. (
   
3. Firstname text,
   
4. Lastname text,
   
5. Salary FLOAT
   
   ,
   
6. DeptID INT
   
7. )
   

Users

Firstname

Lastname

Salary

DeptID

This command will create an empty table with named "Users" and the data types for each column. Now we can populate the table by using SQL INSERT statements.