Data Type problem

[ice_breaker]

I wanna create a table called CustomerDetails.Clients with the coding below, and it's error is "The definition for column 'iClientID' must include a data type". Please advise to fix it. Thanks

Create table CustomerDetails.Clients
(
iClientID identity(1,1) constraint pkCliID Primary Key,
vCompanyName varchar(30) not null,
iContactPerson int(30) not null,
vAddress varchar(50) not null,
vCity varchar(20) not null,
vState varchar(10) not null,
cZip char(10) not null,
vCountry varchar(20)not null,
cPhone char(15) constraint ckPhone (cPhone like '[0-9][0-9]-[0-9][0-9][0-9]-[0-9][0-9][0-9][0-9]-[0-9][0-9][0-9]-[0-9][0-9][0-9]'
)

 

[stopher]

I'm not familiar with SQL for SQL server but my guess would be:

Create table CustomerDetails.Clients
(
iClientID int identity(1,1) constraint pkCliID Primary Key,
vCompanyName varchar(30) not null,
iContactPerson int(30) not null,
vAddress varchar(50) not null,
vCity varchar(20) not null,
vState varchar(10) not null,
cZip char(10) not null,
vCountry varchar(20)not null,
cPhone char(15) constraint ckPhone (cPhone like '[0-9][0-9]-[0-9][0-9][0-9]-[0-9][0-9][0-9][0-9]-[0-9][0-9][0-9]-[0-9][0-9][0-9]'
)

hth
Chris

 

[ice_breaker]

It's been solved. Thanks a lot