Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread How Remove default value of Column using ALTER TABLE
Wed, Jul 19 2006 8:10 PMPermanent Link

Fred Schetterer
How do I remove the default value of a column using the ALTER TABLE SQL function?
What I expected won't work...

ALTER TABLE tablename
REDEFINE ID
DEFAULT NULL
NOBACKUP


thanks

Fred
Wed, Jul 19 2006 9:42 PMPermanent Link

Fred Schetterer
Oops, got it.
After looking at the Delphi AlterTable function I see this is treated as a string and '' did the trick.

Image