Progress
SQL-92
Guide and Reference


Conventional Identifiers

Conventional SQL identifiers must:

SQL does not distinguish between uppercase and lowercase letters in SQL identifiers. It converts all names specified as conventional identifiers to uppercase, but statements can refer to the names in mixed case.

EXAMPLE

The following commands show some of the characteristics of conventional identifiers:

-- Conventional Identifiers
-- Names are case-insensitive
CREATE TABLE ShOwCaSe   (CoLuMn1    character(5));
Update count = 0.
 
INSERT into SHOWCASE    (COLUMN1)   values(’99’);
Update count = 1.
 
Commit work;
 
SELECT * from SHOWCASE;
 
COLUMN1          
---------------- 
99               
 
-- Conventional Identifiers
-- Cannot use reserved words in identifiers
-- Examples: ’table’ and ’column’ cannot be used as identifiers
CREATE TABLE TABLE  (column1    character);
 
=== SQL Exception 1 ===
SQLState=00000
ErrorCode=-20003
Error in executeDirect:Syntax error (7587);Rolledback Xn

CREATE TABLE X      (COLUMN     varchar(10));
 
=== SQL Exception 1 ===
SQLState=00000
ErrorCode=-20003
Error in executeDirect:Syntax error (7587);Rolledback Xn 


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095