Removing Default Value [message #67936] |
Fri, 19 July 2002 11:56 |
Isaac
Messages: 5 Registered: March 2001
|
Junior Member |
|
|
If you've got a table with default values for some fields, and you want to remove the default values, what do you do? Simply deleting the value in the "Default Value" column in the table properties section of the OEM generates a SQL string like:
ALTER TABLE "TABLENAME" MODIFY("FIELDNAME" DEFAULT )
which generates an error because the sowtware is expecting a value after "DEFAULT".
Thanks,
Isaac
|
|
|
|