Q:

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. 

A:

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.

