Overview
ISO/IEC 9075-11:2016/Cor 2:2022 is Technical Corrigendum 2 to Part 11 of the SQL standard (ISO/IEC 9075) - “Information and definition schemas (SQL/Schemata)”. Published June 2022 and prepared by ISO/IEC JTC 1/SC 32, this corrigendum issues targeted corrections and clarifications to the INFORMATION_SCHEMA and DEFINITION_SCHEMA metadata definitions used by SQL implementations. Corrections include revised view and table definitions, syntax fixes, updated conformance rules, and refined CHECK constraints.
Key topics and technical changes
- Corrected view definitions: Several INFORMATION_SCHEMA views are revised (for example, INFORMATION_SCHEMA_CATALOG_NAME, ROUTINE_ROUTINE_USAGE, ROUTINE_SEQUENCE_USAGE) with updated CREATE VIEW statements and SELECT lists to match intended semantics.
- Conformance rule updates: Multiple conformance rules were corrected, removed, or added - clarifying when specific INFORMATION_SCHEMA views must not be referenced depending on features (e.g., application-time period tables, trigger capability, polymorphic table functions).
- Parameter and private-parameter adjustments: The PARAMETERS and PRIVATE_PARAMETERS views had column references corrected and inappropriate column/ConformanceRule entries removed to better reflect polymorphic/function parameter behavior.
- Definition-schema table fixes: The DATA_TYPE_DESCRIPTOR base table and CHARACTER_REPERTOIRES population rules were corrected - including syntax, CHECK constraints, and allowable DATA_TYPE combinations.
- Security / grant statements: Some view definitions explicitly include GRANT SELECT ON ... TO PUBLIC WITH GRANT OPTION to clarify intended access for standardized metadata views.
- Cross-references: This corrigendum modifies or harmonizes subclauses that interact with other SQL parts (e.g., ISO/IEC 9075-4, -9, -13, -14, -15).
Practical applications - who should use this standard
- DBMS implementers and vendors: Use the corrigendum to update metadata view/table implementations so INFORMATION_SCHEMA and DEFINITION_SCHEMA conform to the corrected SQL standard.
- SQL tooling and migration vendors: Ensure metadata discovery, tooling, and compliance tests reflect corrected column names, constraints, and conformance rules.
- DBAs and architects: Rely on updated metadata definitions when writing portable SQL metadata queries or designing cross-vendor catalogs.
- Standards bodies and auditors: Use the corrigendum to clarify conformance assessments, test suites, and interoperability specifications.
Related standards
- ISO/IEC 9075 (SQL) family - particularly Parts referenced in the corrigendum: 9075-4, -9, -13, -14, -15 (these parts contain related subclauses modified by this Corrigendum).
Keywords: ISO/IEC 9075-11:2016/Cor 2:2022, SQL/Schemata, INFORMATION_SCHEMA, DEFINITION_SCHEMA, SQL corrigendum, database metadata, DATA_TYPE_DESCRIPTOR, SQL conformance.