Wednesday, September 15, 2010

What we check while dropping column?

In production, Before dropping any field
on a table, its recommended to check whether
any views are using that fields or not.

for example, As part of encryption if you drop
SSN field on a table without checking any views
then all views shows errors.

So be careful....

No comments:

Post a Comment