• BS ISO/IEC 9075:1992

    Superseded A superseded Standard is one, which is fully replaced by another Standard, which is a new edition of the same Standard.

    INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL

    Available format(s):  Hardcopy, PDF

    Superseded date:  15-05-2000

    Language(s):  English

    Published date:  01-01-1992

    Publisher:  British Standards Institution

    Add To Cart

    Table of Contents - (Show below) - (Hide below)

    Foreword
    Introduction
    1 Scope
    2 Normative references
    3 Definitions, notations and conventions
    4 Concepts
    5 Lexical elements
    6 Scalar expressions
    7 Query expressions
    8 Predicates
    9 Data assignment rules
    10 Additional common elements
    11 Schema definition and manipulation
    12 Module
    13 Data manipulation
    14 Transaction management
    15 Connection management
    16 Session management
    17 Dynamic SQL
    18 Diagnostics management
    19 Embedded SQL
    20 Direct invocation of SQL
    21 Information Schema and Definition Schema
    22 Status codes
    23 Conformance
    Annex
    A Leveling the SQL Language
    A.1 Intermediate SQL specifications
    A.2 Entry SQL specifications
    B Implementation-defined elements
    C Implementation-dependent elements
    D Deprecated features
    E Incompatibilities with ISO/IEC 9075:1989
    F Maintenance and interpretation of SQL
    Index

    Abstract - (Show below) - (Hide below)

    Defines the logical data structures and basic operations for an SQL database. Gives functional capabilities for designing, controlling, accessing, maintaining and protecting the database. Specifies an Information Schema that describes the structure and the integrity constraints of SQL-data. Coverage includes definitions, diagnostics management and data assignment rules. Also gives detailed annexes.

    General Product Information - (Show below) - (Hide below)

    Committee IST/21
    Document Type Standard
    Publisher British Standards Institution
    Status Superseded
    Superseded By
    Supersedes

    Standards Referencing This Book - (Show below) - (Hide below)

    ISO 7185:1990 Information technology Programming languages Pascal
    ISO/IEC 2022:1994 Information technology Character code structure and extension techniques
    ISO/IEC 8824:1990 Information technology — Open Systems Interconnection — Specification of Abstract Syntax Notation One (ASN.1)
    ISO/IEC 1989:2014 Information technology — Programming languages, their environments and system software interfaces — Programming language COBOL
    ISO 1539:1980 Programming languages FORTRAN
    ISO/IEC 11756:1999 Information technology Programming languages M
    ISO 8601:2004 Data elements and interchange formats Information interchange Representation of dates and times
    ISO/IEC 10206:1991 Information technology Progamming languages Extended Pascal
    ISO/IEC 9579-2:1998 Information technology — Open Systems Interconnection — Remote Database Access — Part 2: SQL Specialization
    ISO/IEC 9899:2011 Information technology Programming languages C
    ISO/IEC 646:1991 Information technology ISO 7-bit coded character set for information interchange
    ISO 6160:1979 Programming languages PL/1
    ISO/IEC 8652:2012 Information technology — Programming languages — Ada
    • Access your standards online with a subscription

      Features

      • Simple online access to standards, technical information and regulations
      • Critical updates of standards and customisable alerts and notifications
      • Multi - user online standards collection: secure, flexibile and cost effective