We can use Check constraint to restict the values of any column.

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?

Question Posted / gk

6 Answers
11139 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

Please Help Members By Posting Answers For Below Questions

How many rows can sqlite handle?

1050

how to analyze tables with 'mysqlcheck'? : Sql dba

960

Why stored procedures are faster than query?

971

What is dynamic query?

915

What does where 1 1 mean in sql?

981

Can we commit in trigger?

923

How do you delete a table?

1001

What is meaning of <> in sql?

1023

How do I start sql profiler?

943

how to rename an existing table in mysql? : Sql dba

1006

How delete all records from table in sql?

930

What is difference between mysql and postgresql?

1046

what happens if null values are involved in expressions? : Sql dba

1001

What are the most important ddl statements in sql?

1027

What are system versioned tables?

969