Nested SQL

Quality 0.50 · 1 view · Updated 2 months ago

title: "Nested SQL" type: doc version: 1 created: 2026-02-28 author: "Wikipedia contributors" status: active scope: public tags: ["database-management-systems", "sql", "relational-database-management-systems"] topic_path: "technology/databases" source: "https://en.wikipedia.org/wiki/Nested_SQL" license: "CC BY-SA 4.0" wikipedia_page_id: 0 wikipedia_revision_id: 0

In relational databases, a nested table is a table that is embedded within another table.

Individual elements can be inserted, updated, and deleted in a nested table. Since individual elements can be modified in a nested table, they are more flexible than an array because elements in an array can only be modified as a whole, not individually.

A nested table doesn't have a maximum size, and an arbitrary number of elements can be stored in it.

::callout[type=info title="Wikipedia Source"] This article was imported from Wikipedia and is available under the Creative Commons Attribution-ShareAlike 4.0 License. Content has been adapted to SurfDoc format. Original contributors can be found on the article history page. ::