Javatpoint Logo
Javatpoint Logo

SQL CREATE TABLE

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

If you want to create a table, you should name the table and define its column and each column's data type.

Let's see the simple syntax to create the table.

The data type of the columns may vary from one database to another. For example, NUMBER is supported in Oracle database for integer value whereas INT is supported in MySQL.

Let us take an example to create a STUDENTS table with ID as primary key and NOT NULL are the constraint showing that these fields cannot be NULL while creating records in the table.

You can verify it, if you have created the table successfully by looking at the message displayed by the SQL Server, else you can use DESC command as follows:

SQL> DESC STUDENTS;

FIELDTYPENULLKEYDEFAULTEXTRA
IDInt(11)NOPRI
NAMEVarchar(20)NO
AGEInt(11)NO
ADDRESSVarchar(25)YESNULL

4 rows in set (0.00 sec)

Now you have the STUDENTS table available in your database and you can use to store required information related to students.


SQL CREATE TABLE Example in MySQL

Let's see the command to create a table in MySQL database.


SQL CREATE TABLE Example in Oracle

Let's see the command to create a table in Oracle database.


SQL CREATE TABLE Example in Microsoft SQLServer

Let's see the command to create a table in SQLServer database. It is same as MySQL and Oracle.

Next TopicSQL DROP TABLE




Please Share

facebook twitter google plus pinterest tumbler

Latest 4 Tutorials