what is Constraint? How many types of constraints in SQL ?
Answer Posted / shelly
Constraints are used to limit the type of data that goes
into a table.Constraints can be declared at the time of
creating a table or by altering the already created table.
1)Not Null
2)Unique
3)Primary Key
4)Check
5)References
6)Default
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to start and end transact-sql statements?
What do you mean by table and field in sql?
What are the advantages of having an index on the sql server?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
What is BCNF? How is it better than 2NF & 3NF?
What do you understand by mirroring?
How to assign null values to variables or columns?
What are distinctive joins find as a part of sql?
Explain iaas, paas and saas?
How to encrypt Strored Procedure in SQL SERVER?
What is 2nf normalization?
which table keeps the locking information? : Sql server administration
Determine how to use the inserted and deleted pseudo tables?
What command is used to create a database in the sql server and how?