How to disable IDENTITY COLUMN

Database
N/A

How to disable IDENTITY COLUMN

Hi, what is the syntax in turning off or disabling the IDENTITY COLUMN of a certain table? Thanks.

Tags (1)
1 REPLY
Senior Apprentice

Re: How to disable IDENTITY COLUMN

There's no syntax for disabling it.

You can only set the value when it's defined using BY DEFAULT.

Dieter