Hi everybody,
I'm trying to run this command:
ALTER COLUMN PROPID I NULL ALTER COLUMN SITEID I NULL ALTER COLUMN SITEID2 I NULL ALTER COLUMN ASSRID I NULL ALTER COLUMN TRANID I NULL ALTER COLUMN MISCID I NULL ALTER COLUMN CREDID I NULL ALTER COLUMN COMPLEVL C (1) NULL ALTER COLUMN COMPLEVL DROP CHECK ALTER COLUMN SOURCE C (1) NULL ALTER COLUMN SOURCE DROP CHECK ALTER COLUMN PREFCODE C (1) NULL ALTER COLUMN SITESRCE C (1) NULL ALTER COLUMN CCODE C (2) NULL ALTER COLUMN TOWN C (4) NULL
and I'm getting Error "No rule to drop". I checked table and all rules, which I'm trying to drop, exist. Anyway, this syntax doesn't seem right.
Could you please tell me, what's wrong in this command?
Thanks in advance.
If it's not broken, fix it until it is.
My Blog