Create table in SQL Server

Question

Hi,

I am trying to create a table using

create table DimDestinationVAT (
  id int primary key auto_increment,
  Warehouse_Code varchar(120),
  VAT_Code varchar(120),
  VAT_Value numeric(18,0),
  Date_From To date(),
  Date_To date()
)

However it is returning the error

Msg 102, Level 15, State 1, Line 2
Incorrect syntax near 'auto_increment'.

Any help appreciated.

Answer 1

the auto_increment is not supported by the SQL server. You need to use the IDENTITY property.

create table DimDestinationVAT (  
	id int IDENTITY(1, 1) NOT NULL primary key,  
	Warehouse_Code varchar(120),  
	VAT_Code varchar(120),  
	VAT_Value numeric(18,0),  
	Date_From date,  
	Date_To date  
)  

If you do not specify NOT NULL on the column, the column is nullable.

Answer 2

@Christopher Jack

The above code auto increment is used in MySQL.

For SQL Server use identity

create table DimDestinationVAT (
id int identity primary key,
Warehouse_Code varchar(120),
VAT_Code varchar(120),
VAT_Value numeric(18,0),
Date_From date,
Date_To date
)