CREATE TABLE
1 2 3 4 5 6
CREATE TABLE table_name ( column_name1 data_type, column_name2 data_type, , .... )
data_type Data Types.
For this we use this query:
1 2 3 4 5 6 7
CREATE TABLE Persons ( P_Id int, LastName varchar(255), FirstName varchar(255), Address varchar(255), City varchar(255) )
INSERT INTO.
Username
Password
SQL Create Table
Comments
(
P_Id int identity,
LastName varchar(255),
FirstName varchar(255),
Address varchar(255),
City varchar(255)
)
IDENTITY - a unique identification first number, what type of key))