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.