A table can have 100 columns. But can anybody tell me, For such tables how much constraints can have ?
[b]Question asked by visitor Vinod pandit[/b]
Printable View
A table can have 100 columns. But can anybody tell me, For such tables how much constraints can have ?
[b]Question asked by visitor Vinod pandit[/b]
You can have any number of constrains. If I am not wrong there is not upper limit for constraints on a table.
Check this out for other limitations,
[url]http://www.iselfschooling.com/mc4articles/OracleLimitation.htm[/url]
You can have any number of constraints.There is no restriction in that.
There is no limit to the number of constraints that can be defined on a table. A table can have only one PRIMARY KEY constraint. There is no limit on the number of FOREIGN KEY constraints on that table. But according to the Oracle documentation, "Because composite primary and unique keys are limited to 32 columns, a composite foreign key is also limited to 32 columns." And also from the Oracle documentation, "There is no limit to the number of CHECK constraints that can be defined that reference a column." This statement tells me that there is no limit to the number of total constraints on a table.