ISO/IEC 7816-7:1999

Identification cards — Integrated circuit(s) cards with contacts — Part 7: Interindustry commands for Structured Card Query Language (SCQL)

This part of ISO/IEC 7816 specifies the concept of a SCQL database (SCQL = Structured Card Query Language based on SQL, see ISO 9075) and the related interindustry enhanced commands.

Cartes d'identification — Cartes à circuit(s) intégré(s) à contacts — Partie 7: Commandes intersectorielles pour langage d'interrogation de carte structurée (SCQL)

General Information

• Status: Published
• Publication Date: 10-Mar-1999
• ICS: 35.240.15 - Identification cards. Chip cards. Biometrics
• Technical Committee: ISO/IEC JTC 1/SC 17 - Cards and security devices for personal identification
• Drafting Committee: ISO/IEC JTC 1/SC 17/WG 4 - Generic interfaces and protocols for security devices
• Current Stage: 9093 - International Standard confirmed
• Completion Date: 21-Mar-2024

Relations

• Consolidated By: ISO 3218:2014 - Essential oils — Principles of nomenclature
• Effective Date: 06-Jun-2022

Standards Content (Sample)

INTERNATIONAL ISO/IEC
STANDARD 7816-7
First edition
1999-03-01
Identification cards — Integrated circuit(s)
cards with contacts —
Part 7:
Interindustry commands for Structured Card
Query Language (SCQL)
Cartes d’identification — Cartes à circuit(s) intégré(s) à contacts —
Partie 7: Commandes intersectorielles pour langage d'interrogation de carte
structurée (SCQL)
Reference number
B C
ISO/IEC 7816-7:1999(E)

---------------------- Page: 1 ----------------------
ISO/IEC 7816-7:1999(E)
Contents
1 Scope .1
2 Normative references .1
3 Terms and definitions .1
4 Symbols (and abbreviated terms) .2
5 SCQL database concept .2
5.1 SCQL database .2
5.2 SCQL tables.3
5.3 SCQL views .4
5.4 SCQL system tables and dictionaries .5
5.5 SCQL user profiles .7
6 SCQL related commands .7
6.1 General aspects .7
6.2 Grouping and encoding of commands.8
6.3 Notation and special codings.9
6.4 Status bytes.10
6.5 Coding of identifiers.11
6.6 Security attributes of tables, views and users.12
6.7 Linking user ids to INSERT and UPDATE operations.12
7 Database operations.12
7.1 CREATE TABLE .12
7.2 CREATE VIEW .13
7.3 CREATE DICTIONARY.15
7.4 DROP TABLE.16
7.5 DROP VIEW .17
©  ISO/IEC 1999
All rights reserved. Unless otherwise specified, no part of this publication may be reproduced or utilized in any form or by any means, electronic
or mechanical, including photocopying and microfilm, without permission in writing from the publisher.
ISO/IEC Copyright Office • Case postale 56 • CH-1211 Genève 20 • Switzerland
Printed in Switzerland
ii

---------------------- Page: 2 ----------------------
© ISO/IEC
ISO/IEC 7816-7:1999(E)
7.6 GRANT .
...