Interested to Buy Any Domain ? << Click Here >> for more details...
what is Constraint? How many types of constraints in SQL ?
- 38 Answers
- 88289 Views
- HCL, IBM, NIIT, Wipro, I also Faced
- E-Mail Answers
Answer Posted / ns
constraints are like an a right or any event which can we
apply on our table or column, or its an rule of integrity
there is an types of constraint:-
1.primary key
2.foreign key
3.unique
4.check
5.default
6.not null
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
Explain the difference between delete,drop and truncate in SQL Server?
How to insert and update data into a table with "insert" and "update" statements?
can you implement data mining in SSRS?
What is reportserver and reportservertempdb ?
What is the significance of null value and why should we avoid permitting null values?
What are views in ms sql server?
what is normalization? Explain different levels of normalization? : Sql server database administration
Describe how to use linked server?
Difference between LEN() and DATALENGTH() in sql server ?
How to execute a sql statement using mssql_query()?
What command do we use to rename a database?
What do you mean by recursive stored procedure?
How do I find the transaction log size in sql server?
What are a scheduled jobs?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
