Dependent Origination

add a constraint after table is created

Posted on: December 21, 2011

alter table table_name add constraint constraint_name unique(colomn_names);

apparently if existing values do not respect the constraint, the constraint won’t be created.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

December 2011
M T W T F S S
« Nov   Jan »
 1234
567891011
12131415161718
19202122232425
262728293031  

Twitter

Flickr Photos

Advertisements
%d bloggers like this: