what is Constraint? How many types of constraints in SQL ?
Answer Posted / shankar k
Constraint are used to table columns validations.
there are some constraints.
Primary key,
Foreign Key,
Not Null,
Check,
Unique Key,
default
| Is This Answer Correct ? | 43 Yes | 10 No |
Post New Answer View All Answers
What is the simplest way to create a new database in ms sql server?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
What is sub-query in sql server?
What is save transaction and save point?
Tell me what is the significance of null value and why should we avoid permitting null values?
Define Wed Edition in SQL Azure?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
What are the advantages of stored procedure in sql server?
What is user-defined multi-statement table-valued function?
what is a correlated sub-query? : Sql server database administration
What is subquery? Explain the properties of a subquery?
Why use triggers?
Do you know hot add cpu in sql server 2008?
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
What is hot add cpu in sql server 2008?