Adding an MSSQL Identity field in vb code 1

[MattN]

Could anyone tell me how to add a field in an MS SQL table.

This field must be;-

Integer
Identity = Yes
Identity Seed = 1
Identity Increment = 1


Kind Regards

Matt N

 

[zemp]

How are yout trying to add a field, SQL statements or SQLDMO? Are you creating a table from scratch or adding a field?

Here is how I create an identity field using SQL statements,

CREATE TABLE [Customer] ([CustomerID] [int] IDENTITY (1, 1) NOT NULL ,[Field2]...

Take Care,

zemp

"If the grass looks greener... it's probably because there is more manure."