Saturday, November 7, 2009

Create Queries


CREATE

Syntax


CREATE TABLE "table_name"
("column 1" "data_type_for_column_1",
"column 2" "data_type_for_column_2", ... )


So, if we are to create the customer table specified as above,


CREATE TABLE customer
(First_Name char(50),
Last_Name char(50),
Address char(50),
City char(50),
Country char(25),
DOB date)

No comments:

Post a Comment