what is Constraint? How many types of constraints in SQL ?

Answer Posted / yashwanth

constraints are the rules enforced on data columns on a
table
use:constraints are used to limit the type of data that
can go in to a table

there are some constraints
a primarykey constraint
a unquekey constraint
a foreinkey constraint
a check constraint
a not null constraint
a default constraint

Is This Answer Correct ?    47 Yes 13 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what protocol both networks use? : Sql server database administration

717


How do I connect to sql server database?

685


What is query optimization process?

716


what data regions are and what are the different data regions?

115


What are the purpose of Normalisation?

800






What command would you use to add a column to a table in sql server?

976


What are the difference between “where” and “having” clause in sql server?

749


How to add the custom code in Report?

112


How to search for a string in all stored procedure in sql server?

738


wat wil hapn if we give the both read and deny read permission to user?

1864


How to get a list all databases on the sql server?

778


What is multi-statement table-value user-defined function?

724


How to return the top 5 rows from a select query in ms sql server?

780


Explain aggregate functions?

785


Explain sql delete command?

792