Interested to Buy Any Domain ? << Click Here >> for more details...
what is Constraint? How many types of constraints in SQL ?
- 38 Answers
- 88272 Views
- HCL, IBM, NIIT, Wipro, I also Faced
- E-Mail Answers
Answer Posted / kumari
Constraint are the rules enforced on data columns on table
types of constraints:
PRIMARYKEY
FOREIGN KEY
NOT NULL
UNIQUE KEY
CHECK
DEFAULT
Check
| Is This Answer Correct ? | 111 Yes | 33 No |
Post New Answer View All Answers
How to generate random numbers with the rand() function in ms sql server?
How to copy the tables, schema and views from one sql server to another?
How to get a list of columns in a view using the "sp_columns" stored procedure?
After removing a table from database, what other related objects have to be dropped explicitly?
What is the full form of dql?
How to get a list of columns using the "sys.columns" view in ms sql server?
Do you know what is difference between stored procedure and user defined function?
How to how to convert numeric expression data types using the convert() function??
Explain try...catch with sql server?
What is cross join in sql server joins?
What are the advantages of using cte?
How do you use a subquery to find records that exist in one table and do not exist in another?
Define normalisation?
What are the rules to use the rowguidcol property to define a globally unique identifier column?
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
