Drop a foreign key constraint from a Teradata table
To drop the foreign key reference from a table,
Syntax:
ALTER TABLE {MyDB}.{MyTable} DROP FOREIGN KEY ({ColumnList}) REFERENCES {MyDB}.{MyOtherTable};To drop foreign keys with soft RI:
ALTER TABLE {MyDB}.{MyTable} DROP FOREIGN KEY ({Column}) REFERENCES WITH NO CHECK OPTION {MyDB}.{MyOtherTable}({Column});
nVector
posted on 13 May 18Enjoy great content like this and a lot more !
Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds
Post Comment