Re: Foreign key in Oracle Sql

In non-Oracle product that have implemented ANSI/ISO standards properly, the ALTER TABLE statements (not commands) are a problem. They have to trigger a total validation of the schema to be sure that **all of the constraints** are still valid after the ALTER.

The preferred method is to declare the tables in a single CREATE SCHEMA with all of the constraints in place on each table.

Oracle is still a sequential file structure with sequential creation, failure to conform to even SQL-92 standards. I still marvel that Larry E. can sell it to people. Received on Fri Jan 07 2005 - 19:31:05 CST