Can you limit the number of rows in a table?

[k8277]

When creating a new table, can you specify a max number of rows allowed?

 

[SQLSister]

No. I suppose you could set up an instead of insert trigger which checks the number of rows and then rejects the insert if it is more than the number you want, but why exactly do you care how many rows the table has if the data is all valid data?

Questions about posting. See faq183-874

 

[k8277]

We have an application that writes to a database that potentially has the capability to fill up the disk space on the server if a problem occurs.

 

[JayKusch]

You could set the Max size the DB can grow to suppress filling the disc in case of an error, but that will also create issues when the DB reaches that max and no application or user can change the data.

Thanks

J. Kusch

 

[maswien]

If you create a table like this, it won't let you insert rows more than 99.

create table lrows(thevalue varchar(100), row_id int identity(1,1) check (row_id < 100 ))

 

[maswien]

That assumes there will be no deletion on the table in the table's life time.

 

[mrdenny]

You could create a second file group, put a file in it that can only grow so much, then put this table in that file. But again, if the file fills the insert query will fail.

Denny

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)