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: 65155
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: 65155
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, I forgot FBI.

Regards
Michel
Previous Topic: allocating grades
Next Topic: Pls tell me the difference between these 2 queries...??
Goto Forum:
  


Current Time: Thu Aug 24 05:48:04 CDT 2017

Total time taken to generate the page: 0.04633 seconds