Prevent reverse engineering of encrypted views I have an encrypted view definition in SQL Server that has some information that I want to protect. The definition looks something like this:

CREATE VIEW myview WITH ENCRYPTION AS
SELECT name, age FROM customer WHERE c_city = 'NY'


Now I don't want to expose the fact that the view has a predicate on c_city with the value 'NY'. But when I run the query and see the execution plan for the following query:

SELECT * FROM myview


I can see the predicate on the underlying table with the constant value as well. So anybody can reverse engineer my view logic this way. How can I prevent this?
Bad news: check out dbForge SQL Decryptor. Anyone can decrypt your encrypted objects.