13 May 2018        Add to Favorites   Report

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});

Read great educational content like this and a lot more ! Create my free account now 🎁

Copied