Login
Products
Sales
Support
Downloads
About
Home
»
Technical Support
»
DBISAM Technical Support
»
Support Forums
»
DBISAM SQL
»
View Thread
View Thread
The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
How Remove default value of Column using ALTER TABLE
Wed, Jul 19 2006 8:10 PM
Permanent 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 PM
Permanent 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.