Views

We use Views to remove complexity for an end user by saving a query for future use. Writing a statement where the select is from a table or from a view looks identical, so database architects will often begin the name of a view with a prefix v_ or vw. This is not...

Changing Objects

Change, as they say, is constant. While it would be nice if once we created our objects we didn’t have to alter them again, the reality is just as our data changes, the objects that support that data will often change as well. While making a change to a view is...