The AUTO INCREMENT generates a new number that increment by 1 from the previous number. This will allow a unique number to be associated in a row when it is inserted into a table.
You can set the AUTO INCREMENT during creation of the table or you can also use ALTER TABLE Statement if you have already created the table.
The following example will create a table named "Users" and add a Primary Key with Auto Increment in ID field.
Syntax for SQL Server
The ALTER TABLE statement is used to change the structure of an existing table like adding, deleting, or modifying of column.
SQL ALTER TABLE Syntax
To add a new column to the existing table use the following syntax:
ALTER TABLE table_name
ADD column_name datatype
To remove a column from a table use the following syntax:
ALTER TABLE table_name
DROP TABLE column_name
After you create a database using the CREATE Database statement, you can now create a table. Table is where you store your data in your database.
SQL CREATE TABLE Syntax
CREATE TABLE table_name ( column_name1 data_type, column_name2 data_type, column_name3 data_type, .... )Users