constraint naming schemes

#1 (permalink)

03-31-09, 17:02

rbfree

Registered User

Join Date: Feb 2009

Posts: 104

constraint naming schemes

Is there a preferred rationale for naming constraints?

Is there a relevant name length maximum?

I was thinking about tagging the name of the table to the end of my constraint names to make them unique -- always (I'm thinking) below 40 characters. The table name for the below eg. is bioprocessors.

Code:

CONSTRAINT biomasstypeID_fk_bioprocessors
     FOREIGN KEY (biomasstypeID)
          REFERENCES biomasstypes (biomasstypeID)
,

__________________
In theory, there is no difference between theory and practice. In practice there is.
Disputed Origins

Ninety-three percent of all statistics are made-up on the spot.
Ancient proverb.

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is Off HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules

Internet Services

Web Development

Digital Marketing

Consumer Tech