What are constraints? Explain different types of
constraints?
Answers were Sorted based on User's Feedback
Answer / aravindu chowdary
CONSTRAINTS:
*It is a rule (or) restriction ,which is enforced during a
creation of table.
*constraints raises automatically at the time of
inertion,updation,deletion.
*constraints there are 3 types
1.Domain Integrity
* Not null:Donot allow null value.
* check: Limits the range of values or domain, checks
the values which a col can have
2.Entity Integrity
* Unique key:donot allow duplicate values, but allows
one null per col.Can have multiple unique constraints on a
table
* Primary key : Ensure no duplicate data and not allow
nulls.
3.Refrential Intrgrity
*Forgien key:Referntial integrity b/w 2 tables, one
table col values based on other table col values
| Is This Answer Correct ? | 1 Yes | 4 No |
Answer / the smart one
constraint is something that is restricted or prohibited
for example.
1. Not driving with a license
2. partying after hours if 17 or younger.
| Is This Answer Correct ? | 2 Yes | 6 No |
Answer / rohit
MySQL does not support the use of CHECK constraint
| Is This Answer Correct ? | 4 Yes | 12 No |
Answer / annie choudhary
Constraints are things that are likely to go wrong. There
are three types.
Time constraints
Legal constraints
Finacial constraints
| Is This Answer Correct ? | 15 Yes | 49 No |
Answer / mohib
there are two types of
constraints
1;holonomic
constraint
2;non-holonomic constraints
| Is This Answer Correct ? | 21 Yes | 58 No |
Answer / napster da boss
these are the constarints or codes which an organisation
has to abide by. Not necessarily does any one have to abide
by these, however there are many biles like that can kinda
get peopel to abide by them u get me blud. Dun now this is
dab real macoy doe.
Vote YES for dis 1 if u r a real G u get me.
All ady everyday 2K8 get 2 know.
| Is This Answer Correct ? | 15 Yes | 65 No |
How to add more data to the testing table in ms sql server?
What is a field in a table?
How and why use sql server?
what exactly sql injuction.how to overcome.....
How do I find information about the install locations for the various instances running on a computer?
What is logshipping and its purpose?
What you can do to delete a table without the delete trigger firing?
Difference between DELETE and TRUNCATE?
Can you explain what are commit and rollback in sql?
What is used to replicate sessions between instances in coldfusion clusters?
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)