Some Limitations of SQL
As can be seen from Chapters 11 – 14, SQL is a very powerful programming language, ideally suited for the management of databases. However, like all languages, SQL has limitations. This chapter briefly examines some of these limitations. The chapter proceeds as follows:
- Programming Limitations
- Limitations on Views
- Foreign Key Constraint Specification
- Superfluous Enforcement of Referential Integrity
- Limitations on Calculated Columns
- If-Then Limitation
- Summary and Concluding Remarks
15.1 Programming Limitations
While SQL is a very sophisticated fourth generation language (4GL) for database management, it does ...
Get Database Systems now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.