Constraint and Check Names 2

[Michael42]

Hello,

In a CREATE TABLE script when I indicate NOT NULL for a column a system generated name (SYS_C004567 etc.) is created for the corresponding constraint\check.

How can I indicate the name of the constraint\check rather than taking the system generated name (can you offer an example)?

Thanks,

Michael42

 

[LKBrwnDBA]

Try:

CREATE TABLE MyTable 
(Col1 Number CONSTRAINT Col1_chk NOT NULL
,...etc...);

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[SantaMufasa]

And just a personal-preference addition to LK's excellent example:

Within the 30-character name limitation, I name my constraints as <table_name>_<column_name>_<constraint_type>, where <constraint_type> is:

NN - Not Null
CK - Other Check constraints
UK - Unique Constraint
PK - Primary Key
FK - Foreign Key


Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[Michael42]

LKBrwnDBA, SantaMufasa,

Very useful!


Thanks for posting,

Michael42