Answers
May 08, 2008 - 03:01 PM
You can not drop a check constraint without a 'Constraint Name'.
1) In Oracle, you can get constraint_name from user_constraints or user_col_constraints.
2) Alternatively, you can delete that column first:
ALTER TABLE table_name DROP COLUMN column_name
then re_add that column:
ALTER TABLE table_name ADD column_name ......
1) In Oracle, you can get constraint_name from user_constraints or user_col_constraints.
2) Alternatively, you can delete that column first:
ALTER TABLE table_name DROP COLUMN column_name
then re_add that column:
ALTER TABLE table_name ADD column_name ......
Mar 04, 2009 - 06:02 AM
The question looks to be abandoned by the user who asked it. If no action is taken within 2 days, a Quomon Moderator will consider closing the question and distributing the points.
The Quomon Team
The Quomon Team
Add New Comment