This page is part of the book SQL-99 Complete, Really, by Peter Gulutzan & Trudy Pelzer. The authors have graciously allowed us to reproduce the contents of the book here. Because the book is about the SQL-99 standard, the contents of this and other pages in the book may not directly apply to MariaDB. Use the navigation bar to navigate the book.

INFORMATION_SCHEMA.CARDINAL_NUMBER

Definition:

CREATE DOMAIN CARDINAL_NUMBER AS INTEGER
      CONSTRAINT CARDINAL_NUMBER_DOMAIN_CHECK 
            CHECK (VALUE >= 0)

The set of CARDINAL_NUMBER values includes all non-negative numbers that are less than your DBMS's defined maximum for INTEGER values. (Note: This is probably an error in the Standard CARDINAL_NUMBER should include all non-negative numbers that are less than or equal to your DBMS's defined maximum for INTEGER values.)

INFORMATION_SCHEMA.CHARACTER_DATA

Definition:

CREATE DOMAIN CHARACTER_DATA AS CHARACTER VARYING(ML)
      CHARACTER SET SQL_TEXT

The set of CHARACTER_DATA values includes all character strings, from zero to ML characters long, that belong to the SQL_TEXT Character set. (ML is replaced by your DBMS's defined maximum length for a variable-length character string.)

INFORMATION_SCHEMA.SQL_IDENTIFIER

Definition:

CREATE DOMAIN SQL_IDENTIFIER AS CHARACTER VARYING(L)
      CHARACTER SET SQL_TEXT

The set of SQL_IDENTIFIER values includes all character strings, from one to L characters long, that are valid <regular identifier>s and <delimited identifier> bodies. (L is replaced by your DBMS's defined maximum length for a <regular identifier> and <delimited identifier> body.

INFORMATION_SCHEMA.TIME_STAMP

Definition:

CREATE DOMAIN TIME_STAMP AS TIMESTAMP(2) DEFAULT CURRENT_TIMESTAMP(2)

The set of TIME_STAMP values includes an SQL timestamp value.

Comments

Comments loading...