Loading lesson path

Learn/SQL/SQL References

SQL•SQL References

SQL CREATE TABLE Keyword

Concept visual

SQL CREATE TABLE Keyword

Pointer walk

two pointers

left=0

right=6

Start at both ends

CREATE TABLE Keyword

❮ SQL Keywords

Create Table

The CREATE TABLE

command creates a new table in the database. The following SQL creates a table called "Persons" that contains five columns: PersonID, LastName, FirstName, Address, and City:

Example

CREATE TABLE Persons

( PersonID int, LastName varchar(255), FirstName varchar(255), Address varchar(255),

City varchar(255)

);

CREATE TABLE Using Another Table

The following SQL creates a new table called "TestTables" (which is a copy of two columns of the "Customers" table):

Example

CREATE TABLE TestTable AS

SELECT customername, contactname

From

customers;

❮ SQL Keywords

SQL CREATE OR REPLACE VIEW Keyword

SQL CREATE PROCEDURE Keyword

Loading lesson path

Learn/SQL/SQL References

SQL•SQL References

SQL CREATE TABLE Keyword

Concept visual

SQL CREATE TABLE Keyword

Pointer walk

two pointers

left=0

right=6

Start at both ends

CREATE TABLE Keyword

❮ SQL Keywords

Create Table

The CREATE TABLE

command creates a new table in the database. The following SQL creates a table called "Persons" that contains five columns: PersonID, LastName, FirstName, Address, and City:

Example

CREATE TABLE Persons

( PersonID int, LastName varchar(255), FirstName varchar(255), Address varchar(255),

City varchar(255)

);

CREATE TABLE Using Another Table

The following SQL creates a new table called "TestTables" (which is a copy of two columns of the "Customers" table):

Example

CREATE TABLE TestTable AS

SELECT customername, contactname

From

customers;

❮ SQL Keywords

SQL CREATE OR REPLACE VIEW Keyword

SQL CREATE PROCEDURE Keyword

SQL CREATE TABLE Keyword

SQL CREATE TABLE Keyword

CREATE TABLE Keyword

Previous

Next

Create Table

The CREATE TABLE

Example

CREATE TABLE Persons

City varchar(255)

CREATE TABLE Using Another Table

Example

CREATE TABLE TestTable AS

From

Previous

Next

SQL CREATE TABLE Keyword

SQL CREATE TABLE Keyword

CREATE TABLE Keyword

Previous

Next

Create Table

The CREATE TABLE

Example

CREATE TABLE Persons

City varchar(255)

CREATE TABLE Using Another Table

Example

CREATE TABLE TestTable AS

From

Previous

Next