![]() CASCADE will drop a column with a foreign key constraint if it is the only column in the reference.ĬASCADE does not list the objects it drops, so should be used cautiously.ĬASCADE is not required to drop an indexed column, or a column that is referenced by an index. ![]() When a column with a CHECK constraint is dropped, the CHECK constraint is also dropped.ĭrop the column even if objects (such as views) depend on it drop the dependent objects, as well. The name of the table with the column you want to drop. The user must have the CREATE privilege on the table. ![]() ![]() ALTER TABLE IF EXISTS table_name DROP COLUMN IF EXISTS name CASCADE RESTRICT Required privileges
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |