Home » SQL & PL/SQL » SQL & PL/SQL » How Many unique constraints can be allowed for a Table? (Oracle 10 G)
How Many unique constraints can be allowed for a Table? [message #327932] Wed, 18 June 2008 07:08 Go to next message
rangan.s
Messages: 75
Registered: February 2008
Location: chennai
Member
How Many unique constraints can be allowed for a Table?
Re: How Many unique constraints can be allowed for a Table? [message #327935 is a reply to message #327932] Wed, 18 June 2008 07:11 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The number of combinations of different columns of the table.

Regards
Michel
Re: How Many unique constraints can be allowed for a Table? [message #327960 is a reply to message #327935] Wed, 18 June 2008 07:50 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Even more than that, if you're on 10g.

You can create unique function based indexes to enforce additional uniqueness constraints.

Documentation
Re: How Many unique constraints can be allowed for a Table? [message #327969 is a reply to message #327960] Wed, 18 June 2008 08:24 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, I forgot FBI.

Regards
Michel
Previous Topic: Regular expression
Next Topic: Suggest for Error
Goto Forum:
  


Current Time: Sun Dec 04 00:35:37 CST 2016

Total time taken to generate the page: 0.07110 seconds