Create column: int identity

[Supe]

Does anyone know how to create a column with "int identity"?

[PeterHeintz]

Do not understand what you are asking for!
What kind of column you want to create?
And what do you mean with in identity?

[qwerty]

He's probably after some feature in the database engineering. Though some people think "Houston, we have a problem" will describe their issue, they obviously forget they are not in an Apollo capsule.

q.

[Supe]

Yeah I realise now that my question was a tad vague.

I guess an example of this would be:

CREATE TABLE XXX (
   ID int identity(1,1)  NOT NULL,
   Name varchar(100) NOT NULL

So adding a data type of int and including "identity" to it is what i'm after. It seems it can be done, but I can't understand how it was done.

[qwerty]

Unless someone else with more profession chips in (it's too long ago I last used it): In the past there was a transformation script generating the DLL. This could be modified to your needs. No idea whether that's still present. If you you could probably use tagged values to achieve the right results.

q.