what is Constraint? How many types of constraints in SQL ?
Answer Posted / nivetha sri
Constraint are the certain condition which is used to
limit the data in the table.It can used before creating the
table and after creating the table.
TYPES OF CONSTRAINTS
1] Primary key
2]Foreign key
3]Unique key
4]Check
5]Not Null
6]Default
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are trace files?
What are transactions in sql?
What are views in ms sql server?
How to declare a cursor with "declare ... Cursor" in ms sql server?
Equi join and non equi join is possible with sql server?
What do you understand by a view?
Tell me what is fill factor?
Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?
What is the difference RDBMS and Graph Database?
What is a result set object returned by odbc_exec()?
What types of replication are supported in sql server?
Is sql server difficult to learn?
What is the difference between the 2 operating modes of database mirroring?
Tell me what is the significance of null value and why should we avoid permitting null values?
What are commonly used mssql functions in php?