CODEWITHSUNDEEP
sqlsqlite
ajayks
ajayks

Reputation: 35

Limit number of Rows inserted into a Table

How can we restrict a table to have fixed number of rows? for example if i give Limit as 20, then 20 rows can be inserted into it and after that table should indicate the limit has been exceeded.

EXAMPLE: IF we create a trigger 

 CREATE TRIGGER log AFTER INSERT ON TEST_TABLE
 BEGIN
 INSERT INTO TEST_TABLE VALUES(....);
 SELECT COUNT(COL) FROM TEST_TABLE;
 END;

This is not giving me the count as soon as i enter a row into the table.

Upvotes: 1

Views: 1954

Answers (1)

Romesh
Romesh

Reputation: 2274

Create a Trigger before Insert on That table. In Trigger you can check for count for records that same table has.

Check this link for Creating Trigger.

Upvotes: 2

Related Questions