What are constraints? Explain different types of
constraints?
Answer Posted / satyanarayana
Constraints are the constraints which can provide on the
column data.The types of constraints are
1).Domain Integrity constraints
EX:Check
2).Entity Integrity constraints
Ex:Unique,Primary key
3).Referential Integrity constraints
EX:Foreignkey
| Is This Answer Correct ? | 136 Yes | 41 No |
Post New Answer View All Answers
What do you understand by user-defined function in the sql server?
How to delete a database in ms sql server?
List all types of constraints in sql server?
How to implement service broker?
How many types of local tables are there in sql server?
What is a partition key?
If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?
What is an index. What are the types?
What the different components in replication and what is their use?
What are the differences between substr and charindex in sql server.
How to list all schemas in a database?
What is 'Join' and explain its various types.
How to verify a login name with sqlcmd tool?
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
What is a coalesce function?