Sybase Error – Cannot drop %1 %2: set option ‘identity_insert’ must be off.

In this blog post, you’ll learn more about the Sybase Error Cannot drop %1 %2: set option ‘identity_insert’ must be off. and the reason for receiving this error

Sybase SQL Error Message

Cannot drop %1 %2: set option ‘identity_insert’ must be off.

Reason for this Error

option ‘identity insert’ must not be set to any table name to drop an Identity Column. To turn it off use ‘set identity_insert ” ‘