Easy Tutorial
Sql Having Sql Func Mid Sql Between Sql Drop Sql Wildcards Sql Join Inner Sql Join Full Sql Func Lcase Sql Where Sql Join Sql Func Round Sql Primarykey Sql Func First Sql Func Len Sql Distinct Sql Func Ucase Sql Function Sql Delete Sql Autoincrement Func Curtime Sql Update Sql Isnull Func Date Sub Sql Constraints Sql Intro Sql Dates Sql Select Into Sql Hosting Sql Create Table Sql Func Format Sql View Sql Func Count Sql Index Sql Like Sql Datatypes General Sql Datatypes Func Convert Sql Func Avg Sql Foreignkey Sql Func Sum Sql Join Right Func Curdate Sql Alias Sql Union Func Date Add Sql Groupby Sql Summary Sql In Sql Null Values Sql Syntax Sql Tutorial Sql Insert Into Select Sql And Or Sql Join Left Sql Func Now Func Date Sql Top Index Sql Create Db Sql Unique Sql Check Func Extract Sql Alter Sql Notnull Func Now Sql Select Sql Insert Sql Func Max Sql Exists Sql Func Min Func Date Format Func Datediff Mysql Func Getdate Sql Orderby Func Datediff Sql Func Last Sql Create Index Func Dateadd Sql Quickref Func Datepart
❮ Sql Hosting Sql Func Format ❯

SQL CREATE TABLE Statement

SQL CREATE TABLE Statement

The CREATE TABLE statement is used to create a table in the database.

A table consists of rows and columns, and each table must have a table name.

SQL CREATE TABLE Syntax

The column_name parameter specifies the name of the column in the table.

The data_type parameter specifies the data type of the column (e.g., varchar, integer, decimal, date, etc.).

The size parameter specifies the maximum length of the column in the table.

Note: For information on available data types in MS Access, MySQL, and SQL Server, please visit our complete Data Types Reference.

SQL CREATE TABLE Example

Now we want to create a table named "Persons" with five columns: PersonID, LastName, FirstName, Address, and City.

We use the following CREATE TABLE statement:

Example

The data type of the PersonID column is int, which contains integers.

The data type of the LastName, FirstName, Address, and City columns is varchar, which contains characters, and the maximum length of these fields is 255 characters.

The empty "Persons" table looks like this:

PersonID LastName FirstName Address City

Note: You can use the INSERT INTO statement to insert data into an empty table.

❮ Sql Hosting Sql Func Format ❯