An Easy Way to Make a SQL Table Read Only

Here’s a very simple way to make a SQL table read only (except for deletes) using a constraint. It adds the always-failing constraint with nocheck so that it doesn’t fail existing records.

ALTER TABLE VisitGeoIpData WITH NOCHECK ADD CONSTRAINT chk_read_only CHECK( 1 = 0 )