What are constraints? Explain different types of
constraints?
Answer Posted / kannan g
Constraints are used to restrict or protect the data and
accessing from the table
There are 5 types of constraints available,
That,
1.Primary-which is not allowed duplication and Null values
2.Unique-Which is also Not allowed duplication But It is
allowed one single null values
3.Foreign - Which is allowed duplication and Null values.
But It refers Value from primary Key table to its own table
Value.
4.Check Constratints
5.Not null
Is This Answer Correct ? | 10 Yes | 10 No |
Post New Answer View All Answers
Where the sql logs gets stored?
What is data block and how to define data block size?
What is abstracting periodical?
What is database white box testing?
What does the not null constraint do?
Do you know what guidelines should be followed to help minimize deadlocks?
What the difference between UNION and UNIONALL?
What does it mean to manipulate data?
What are Row versions of DataRow?
What is the difference between varchar and varchar(max) datatypes?
Which Model uses the SET concept
What are the events recorded in a transaction log?
Explain the difference between cross join and full outer join?
Write a sql query to delete duplicate records from a table called table1
What are the types of subscriptions in SQL Server replication?