O'Reilly logo

Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL by Joe Celko

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

6.9. Outdated Uses for VIEWs

Over the years, VIEWs have been used for other purposes that made sense at the time, but have been rendered obsolete with the advent of new DBMS functionality. You no longer need to program this way, but you might run into it in some old schémas. Each SQL product’s programmers tended to use some of these tricks more than other products, so finding them is more of a local dialect problem than an exact science.

Two of these VIEW usages are to simulate domain support and to implement queries that access both summary and detail information in a single row. Let me elaborate on both and tell you why these usages are outdated.

6.9.1. Domain Support

It is a sad fact of life that most relational database management systems ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required