ISO/IEC 9075-11:2023

Information technology — Database languages SQL — Part 11: Information and definition schemas (SQL/Schemata)

Technologies de l'information — Langages de base de données SQL — Partie 11: Schémas des informations et des définitions (SQL/Schemata)

General Information

• Status: Published
• Publication Date: 31-May-2023
• ICS: 35.060 - Languages used in information technology
• Technical Committee: ISO/IEC JTC 1/SC 32 - Data management and interchange
• Drafting Committee: ISO/IEC JTC 1/SC 32/WG 3 - Database language
• Current Stage: 9092 - International Standard to be revised
• Start Date: 22-Jun-2025
• Completion Date: 28-Jun-2025

Relations

• Revises: ISO/IEC 9075-11:2016/Cor 2:2022 - Information technology — Database languages — SQL — Part 11: Information and definition schemas (SQL/Schemata) — Technical Corrigendum 2
• Effective Date: 11-Feb-2023

Standards Content (Sample)

INTERNATIONAL ISO/IEC
STANDARD 9075-11
Fifth edition
2023-06
Information technology — Database
languages SQL —
Part 11:
Information and definition schemas
(SQL/Schemata)
Technologies de l'information — Langages de base de données SQL —
Partie 11: Schémas des informations et des définitions (SQL/
Schemata)
Reference number
© ISO/IEC 2023
© ISO/IEC 2023
All rights reserved. Unless otherwise specified, or required in the context of its implementation, no part of this publication may
be reproduced or utilized otherwise in any form or by any means, electronic or mechanical, including photocopying, or posting on
the internet or an intranet, without prior written permission. Permission can be requested from either ISO at the address below
or ISO’s member body in the country of the requester.
ISO copyright office
CP 401 • Ch. de Blandonnet 8
CH-1214 Vernier, Geneva
Phone: [phone]
Email: [e-mail]
Website: www.iso.org
Published in Switzerland
ii
© ISO/IEC 2023 – All rights reserved

ISO/IEC9075-11:2023(E)
Contents Page
Foreword.ix
Introduction.xi
1 Scope.1
2 Normativereferences.2
3 Termsanddefinitions.3
4 Concepts.4
4.1 Notationsandconventions.4
4.1.1 Notations.4
4.1.2 ValuesinDescriptions.4
4.2 IntroductiontotheDefinitionSchema.4
4.3 IntroductiontotheInformationSchema.5
5 Lexicalelements.7
5.1 and.7
6 Information Schema.8
6.1 InformationSchemadigitalartifact.8
6.2 INFORMATION_SCHEMA Schema.8
6.3 INFORMATION_SCHEMA_CATALOG_NAMEview.9
6.4 CARDINAL_NUMBER domain.10
6.5 CHARACTER_DATAdomain.11
6.6 SQL_IDENTIFIERdomain.12
6.7 TIME_STAMPdomain.13
6.8 YES_OR_NO domain.14
6.9 ADMINISTRABLE_ROLE_AUTHORIZATIONSview.15
6.10 APPLICABLE_ROLES view.16
6.11 ASSERTIONSview.17
6.12 ATTRIBUTESview.18
6.13 CHARACTER_SETSview.20
6.14 CHECK_CONSTRAINT_ROUTINE_USAGEview.21
6.15 CHECK_CONSTRAINTS view.22
6.16 COLLATIONSview.23
6.17 COLLATION_CHARACTER_SET_APPLICABILITYview.24
6.18 COLUMN_COLUMN_USAGEview.25
6.19 COLUMN_DOMAIN_USAGE view.26
6.20 COLUMN_PRIVILEGESview.27
6.21 COLUMN_UDT_USAGEview.28
6.22 COLUMNSview.29
6.23 CONSTRAINT_COLUMN_USAGE view.32
6.24 CONSTRAINT_PERIOD_USAGEview.34
©ISO/IEC2023–Allrightsreserved iii

ISO/IEC9075-11:2023(E)
6.25 CONSTRAINT_TABLE_USAGE view.36
6.26 DATA_TYPE_PRIVILEGESview.37
6.27 DIRECT_SUPERTABLESview.38
6.28 DIRECT_SUPERTYPESview.39
6.29 DOMAIN_CONSTRAINTSview.40
6.30 DOMAINS view.41
6.31 ELEMENT_TYPESview.43
6.32 ENABLED_ROLESview.45
6.33 FIELDS view.46
6.34 KEY_COLUMN_USAGE view.47
6.35 KEY_PERIOD_USAGE view.49
6.36 METHOD_SPECIFICATION_PARAMETERSview.50
6.37 METHOD_SPECIFICATIONSview.52
6.38 PARAMETERSview.54
6.39 PERIODSview.56
6.40 PRIVATE_PARAMETERS view.58
6.41 REFERENCED_TYPES view.60
6.42 REFERENTIAL_CONSTRAINTSview.61
6.43 ROLE_COLUMN_GRANTSview.62
6.44 ROLE_ROUTINE_GRANTS view.63
6.45 ROLE_TABLE_GRANTSview.64
6.46 ROLE_TABLE_METHOD_GRANTSview.65
6.47 ROLE_USAGE_GRANTS view.66
6.48 ROLE_UDT_GRANTSview.67
6.49 ROUTINE_COLUMN_USAGEview.68
6.50 ROUTINE_PERIOD_USAGE view.69
6.51 ROUTINE_PRIVILEGES view.70
6.52 ROUTINE_ROUTINE_USAGE view.71
6.53 ROUTINE_SEQUENCE_USAGEview.72
6.54 ROUTINE_TABLE_USAGEview.73
6.55 ROUTINESview.74
6.56 SCHEMATA view.77
6.57 SEQUENCES view.78
6.58 SQL_FEATURES view.79
6.59 SQL_IMPLEMENTATION_INFO view.80
6.60 SQL_PARTSview.81
6.61 SQL_SIZINGview.82
6.62 TABLE_CONSTRAINTSview.83
6.63 TABLE_METHOD_PRIVILEGES view.84
6.64 TABLE_PRIVILEGESview.85
6.65 TABLESview.86
6.66 TRANSFORMS view.87
6.67 TRANSLATIONSview.88
6.68 TRIGGERED_UPDATE_COLUMNSview.89
6.69 TRIGGER_COLUMN_USAGEview.90
6.70 TRIGGER_PERIOD_USAGEview.91
6.71 TRIGGER_ROUTINE_USAGE view.92
iv ©ISO/IEC2023–Allrightsreserved

ISO/IEC9075-11:2023(E)
6.72 TRIGGER_SEQUENCE_USAGEview.93
6.73 TRIGGER_TABLE_USAGEview.94
6.74 TRIGGERSview.95
6.75 UDT_PRIVILEGESview.97
6.76 USAGE_PRIVILEGESview.98
6.77 USER_DEFINED_TYPESview.99
6.78 VIEW_COLUMN_USAGEview.101
6.79 VIEW_PERIOD_USAGEview.102
6.80 VIEW_ROUTINE_USAGE view.103
6.81 VIEW_TABLE_USAGEview.104
6.82 VIEWSview.105
6.83 Shortnameviews.106
7 DefinitionSchema.126
7.1 DefinitionSchemadigitalartifact.126
7.2 DEFINITION_SCHEMA Schema.126
7.3 EQUAL_KEY_DEGREESassertion.127
7.4 KEY_DEGREE_GREATER_THAN_OR_EQUAL_TO_1 assertion.128
7.5 UNIQUE_CONSTRAINT_NAME assertion.129
7.6 ASSERTIONSbasetable.130
7.7 ATTRIBUTESbasetable.132
7.8 AUTHORIZATIONSbasetable.134
7.9 CATALOG_NAMEbasetable.135
7.10 CHARACTER_ENCODING_FORMSbasetable.136
7.11 CHARACTER_REPERTOIRESbasetable.138
7.12 CHARACTER_SETSbasetable.140
7.13 CHECK_COLUMN_USAGEbasetable.143
7.14 CHECK_CONSTRAINT_ROUTINE_USAGEbasetable.144
7.15 CHECK_CONSTRAINTSbasetable.145
7.16 CHECK_PERIOD_USAGEbasetable.146
7.17 CHECK_TABLE_USAGEbasetable.147
7.18 COLLATIONSbasetable.148
7.19 COLLATION_CHARACTER_SET_APPLICABILITYbasetable.150
7.20 COLUMN_COLUMN_USAGEbasetable.152
7.21 COLUMN_PRIVILEGESbasetable.153
7.22 COLUMNSbasetable.155
7.23 DATA_TYPE_DESCRIPTORbasetable.159
7.24 DIRECT_SUPERTABLESbasetable.170
7.25 DIRECT_SUPERTYPESbasetable.172
7.26 DOMAIN_CONSTRAINTSbasetable.174
7.27 DOMAINSbasetable.176
7.28 ELEMENT_TYPESbasetable.177
7.29 FIELDSbasetable.179
7.30 KEY_COLUMN_USAGEbasetable.181
7.31 KEY_PERIOD_USAGEbasetable.183
7.32 METHOD_SPECIFICATION_PARAMETERSbasetable.185
7.33 METHOD_SPECIFICATIONSbasetable.187
7.34 PARAMETERSbasetable.191
©ISO/IEC2023–Allrightsreserved v

ISO/IEC9075-11:2023(E)
7.35 PERIODSbasetable.194
7.36 PRIVATE_PARAMETERSbasetable.195
7.37 REFERENCED_TYPESbasetable.197
7.38 REFERENTIAL_CONSTRAINTSbasetable.199
7.39 ROLE_AUTHORIZATION_DESCRIPTORSbasetable.201
7.40 ROUTINE_COLUMN_USAGEbasetable.203
7.41 ROUTINE_PERIOD_USAGEbasetable.204
7.42 ROUTINE_PRIVILEGESbasetable.205
7.43 ROUTINE_ROUTINE_USAGEbasetable.207
7.44 ROUTINE_SEQUENCE_USAGEbasetable.208
7.45 ROUTINE_TABLE_USAGEbasetable.209
7.46 ROUTINESbasetable.210
7.47 SCHEMATAbasetable.218
7.48 SEQUENCESbasetable.220
7.49 SQL_CONFORMANCEbasetable.222
7.50 SQL_IMPLEMENTATIO
...