BS IS0/IEC 9075-11:2023 BSl Standards Publication Information technology Database languages SQL Part 11: Information and definition schemas (SQL/Schemata) bsi. BSIS0/IEC9075-11:2023 BRITISH STANDARD National foreword This British Standard is the UK implementation of IS0/IEC 9075-11:2023 The UK participation in its preparation was entrusted to Technical Committee IST/40, Data management and interchange. A list of organizations represented on this committee can be obtained on request to its committee manager. Contractual and legal considerations This publication has been prepared in good faith, however no representation, warranty, assurance or undertaking (express or implied) is or will be made, and no responsibility or liability is or will be accepted by BsI in relation to the adequacy, accuracy, completeness or reasonableness of this publication. All and any such responsibility and liability is expressly disclaimed to the full extent permitted by the law. This publication is provided as is, and is to be used at the recipient's own risk. The recipient is advised to consider seeking professional guidance with respect to its use of this publication. This publication is not intended to constitute a contract. Users are responsible for its correct application. @ The British Standards Institution 2023 Published by BSI Standards Limited 2023 ISBN 978 0 539 16121 2 ICS 35.060 Compliance with a British Standard cannot confer immunity from legal obligations. This British Standard was published under the authority of the Standards Policy and Strategy Committee on 30 June 2023. Amendments/corrigenda issued since publication Date Textaffected BS IS0/IEC 9075-11:2023 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 I'information - Langages de base de données SQL - Partie 11: Schémas des informations et des définitions (SQL) Schemata) Reference number IEC IS0/IEC 9075-11:2023(E) ISO @ IS0/IEC 2023 BSISO/IEC 9075-11:2023 IS0/IEC 9075-11:2023(E) COPYRIGHTPROTECTEDDOCUMENT @IS0/IEC2023 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 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: +41 22 749 01 11 Email: [email protected] Website: www.iso.org Published in Switzerland i @ IS0/IEC 2023 - All rights reserved BSIS0/IEC9075-11:2023 IS0/IEC 9075-11:2023(E) Contents Page Foreword.. .ix Introduction. xi 1 Scope.. 2 Normative references.. 2 3 Terms and definitions. 4 Concepts. 4.1 Notations and conventions. 4.1.1 4.1.2 Values in Descriptions. . 4.2 Introduction to the Definition Schema. . 4.3 Introduction to the Information Schema. 5 Lexical elements. .. . 5.1 <token> and <separator>. 6 Information Schema.. 6.1 Information Schema digital artifact. 6.2 INFORMATION_SCHEMA Schema. . 6.3 INFORMATION_SCHEMA_CATALOG_NAME view. . 6.4 CARDINAL_NUMBER domain.. 10 6.5 CHARACTER_DATA domain.. 11 6.6 SQL_IDENTIFIER domain. . 12 6.7 TIME_STAMP domain. 13 6.8 YES_OR_NO domain. . 6.9 ADMINISTRABLE_ROLE_AUTHORIZATIONS viewW. 6.10 APPLICABLE_ROLES view... 6.11 ASSERTIONS view. . . . 6.12 ATTRIBUTESvieW.. 6.13 CHARACTER_SETS view. 6.14 CHECKCONSTRAINTROUTINEUSAGEvieW.. 6.15 CHECK_CONSTRAINTSvieW. 6.16 COLLATIONS view. . 6.17 COLLATION_CHARACTER_SET_APPLICABILITY vieW. .24 6.18 COLUMN_COLUMN_USAGE view. .25 6.19 COLUMN_DOMAIN_USAGE view.. .26 6.20 COLUMN_PRIVILEGES view. . .27 6.21 COLUMN_UDT_USAGE view.. .28 6.22 COLUMNS view. . .29 6.23 CONSTRAINT_COLUMN_USAGE view. .32 6.24 CONSTRAINT_PERIOD_USAGE view. .34 @ IS0/IEC 2023 - All rights reserved iii BSIS0/IEC9075-11:2023 IS0/IEC 9075-11:2023(E) Contents Page Foreword.. .ix Introduction. xi 1