What do you understand by check constraint in sql server?
- 1 Answers
- 1059 Views
- I also Faced
- E-Mail Answers
Answer Posted / Firatoo Prasad
A check constraint is a rule that is defined at the column or table level in SQL Server to ensure that only valid data is inserted, updated, or deleted in a table. Check constraints can be used to enforce business rules and ensure data consistency.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a scheduled job or what is a scheduled task?
What is self contained sub query?
How can you append an identity column to a temporary table?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
Can one drop a column from a table?
Is it possible to have clustered index on separate drive from original table location?
What are wait types?
How do I create a trace in sql server?
Can we do dml on views?
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?
List the ways in which dynamic sql can be executed?
How do I find query history in sql server?
What are the properties of the transaction?
Equi join and non equi join is possible with sql server?
What is clustered index
