CREATE TABLE

Introduction

The CREATE TABLE statement is used create a new table in the database. A table definition consists of a list of columns, their types, and any integrity constraints.

Syntax

• CREATE TABLE tableName( [ColumnName1] [datatype1] [, [ColumnName2] [datatype2] …] )

Parameters

|Parameter | Details | |————|—–| |tableName|The name of the table| |columns | Contains an ‘enumeration’ of all the columns that the table have. See Create a New Table for more details.|

Remarks

Table names must be unique.