April 22, 2009 Paul Tuohy
I recently had a discussion with some of my colleagues about the increased use of Data Definition Language (DDL) in SQL to define a database as opposed to traditional DDS. One of the items that came up in the discussion was that while people were using DDL to define tables and indexes, there seemed to be very few views being defined.
In this article I will discuss some of the benefits to be gained from using views–both within your applications and as a means to make data more readily accessible to your users.
What Is a View?
Those of us