ALTER TABLE emp
ADD CONSTRAINT read_only CHECK (1=1) DISABLE VALIDATE;
It is now, impossible to insert, update or delete anything with this table.
Friday, January 18, 2008
How to set a table in read-only mode ?
Subscribe to:
Post Comments (Atom)
1 comment:
Great post! Thank for sharing ! This is what I was try from last 1 hour but doing very silly mistake. I just tried again after reading your post & it worked perfectly. :)
sap upgrades
Post a Comment