sql server - Set Limit for a Table Rows In SQL

Question

I want to set the limit for my table's rows. How can I do it?

For example 50 rows in my table.

Answer 1

Create an AFTER INSERT trigger on the table. Here's something that would be relatively effective with your requirement:

create trigger LimitTable
on YourTableToLimit
after insert
as
    declare @tableCount int
    select @tableCount = Count(*)
    from YourTableToLimit

    if @tableCount > 50
    begin
        rollback
    end
go