new SQL keyword: might-be
05/17/06 02:44 PM

Have you ever known someone who still confuses relational databases with flat file strutures? Someone that would rather have the application define data relationships than constrain them in the database? I would like to propose a comprimise with those people by introducing a new sql keyword. Take a look at the new might-be constraint:

alter table SCHEMA.MY_TABLE add might-be constraint MY_TABLES_FK foreign key (ASSIGN_ID) might reference SCHEMA.OTHER_TABLE(ID);
Comments (1)