Constraint Naming in Oracle

From: Mark David Butler <butlerm_at_xmission.xmission.com>
Date: 1996/01/06
Message-ID: <4clvut$8fu_at_xmission.xmission.com>#1/1


Can Oracle table integrity constraints have the same name for different tables in the same schema?

I am in the processes of writing a DDL generation tool for Oracle and the SQL Reference manual section on namespaces is vague on this point. I would like to use a naming convention of CHECK_attribute_name for all my check constraints, but am not sure whether this is allowed and even more important, is it legal?

Thanks in advance for any help you can give.

  • Mark Butler
-- 
Mark David Butler         ( butlerm _at_ xmission.com )
Received on Sat Jan 06 1996 - 00:00:00 CET

Original text of this message