Interested to Buy Any Domain ? << Click Here >> for more details...
how do you restrict number of rows for a particular value
in a column.For example:there is a table called
fruits,having apples,bananas ,papayas.I dont want to have
more than 100 apples in that table ,so how can u restrict
number of rows for apple to hundred?
- 6 Answers
- 11411 Views
- I also Faced
- E-Mail Answers
Answer Posted / gk
We can use Check constraint to restict the values of any
column.
| Is This Answer Correct ? | 12 Yes | 3 No |
Post New Answer View All Answers
what is a constraint? Tell me about its various levels. : Sql dba
what is the difference between char and varchar data types? : Sql dba
How can triggers be used for the table auditing?
Is primary key clustered or nonclustered?
What is sql trigger example?
How do I view a sql trace file?
How many columns should be in an index?
Does a join table need a primary key?
What is asqueryable?
Why we use cross join?
Does sql profiler affect performance?
Is mariadb a nosql database?
Why do we need sharding?
Explain the purpose of %type and %rowtype data types?
what are integrity rules?
