what is Constraint? How many types of constraints in SQL ?
Answer Posted / srinivas
Constraint are the rules enforced on data columns on table
Five type of constraints
Primary key
Unique Key
Foreign Key
Not Null
Check
| Is This Answer Correct ? | 28 Yes | 14 No |
Post New Answer View All Answers
How to check if stored procedure is running in sql server?
Mention the differences between having and where clause.
What is the difference between a check constraint and a rule?
Write a SQL queries on Self Join and Inner Join.
What is data compression?
How you would rewrite the sql query to return the customerid sorted numerically?
How to scale out a federation by Sql statement?
What is the maximum size of column in sql server?
What is pivot and unpivot?
Do you know what are the restrictions that views have to follow?
when would you go for denormalization? : Sql server database administration
Can you use order by when defining a view?
What stored procedure would you use to view lock information?
What is the difference between count () and rowcount ()?
what is the system function to get current user's user id? : Sql server database administration