SQL Tutorial
- SQL Introduction
- SQL Syntax
- SQL RDBMS Concepts
- SQL DataBases
- SQL Data types
- SQL Operators
- SQL Create DataBase
- SQL Create Table
- SQL Distinct
- SQL Rename Database
- SQL Rename Table
- SQL Drop Database
- SQL Select Query
- SQL Insert Query
- SQL Where Clasuse
- SQL Update Query
- SQL Delete Query
- SQL Like Query
- SQL Check
- SQL Default
- SQL Group By
- SQL Between
- SQL In
- SQL Views
- SQL Dates
- SQL Order By
- SQL Constraints
- SQL Not Null
- SQL And & Or
- SQL Unique Key
- SQL Primary Key
- SQL Foreign Key
- SQL Join
- SQL Inner Join
- SQL Left Join
- SQL Right Join
- SQL Full Join
- SQL Function
- SQL Avg()
- SQL Format()
- SQL Now()
- SQL Round()
- SQL Len()
- SQL Mid()
- SQL lowercase() & Uppercase()
- SQL Sum()
- SQL Min() & Max()
- SQL First() & Last()
- SQL Count()
SQL Create Table
SQL CREATE TABLE statement is used to create table in a database.
To create a table, you should name the table and define its column and each column's data type.
Syntax
CREATE TABLE table_name ( column_name1 DATATYPE, column_name2 DATATYPE, ... column_nameN DATATYPE )
- table_name - is the name of the table.
- column_name1, column_name2.... - is the name of the columns
- datatype - is the datatype for the column like char, date, number etc.
CREATE TABLE is the keyword telling the database system what you want to do. In this case, you want to create a new table. The unique name or identifier for the table follows the CREATE TABLE statement.
Example
CREATE TABLE Persons ( personID INT [10], lastName VARCHAR(255), firstName VARCHAR(255), address VARCHAR(255), city VARCHAR(255) )