Progress
SQL-89
Guide and Reference
Identifiers
Identifiers are names that you give to language elements. All of the following elements are identifiers:
Identifiers can be up to 32 characters long and are not case sensitive. The first character must be an uppercase or lowercase letter. The remainder of the identifier can be any combination of letters (A-Z and a-z), digits (0-9), and underscore ( _ ) characters. You cannot use any of the SQL special characters (except for the underscore character) as part of an identifier.
You cannot use SQL reserved words or Progress reserved words as identifiers, except for ORDER; ORDER is not a reserved word, so you can use it in the Sports demonstration database to refer to the Order table. For a list of SQL and Progress reserved words, see the Progress Language Reference.
A table or view name must be unique within a database. A column name must be unique within a table; however, you can have duplicate column names within a database. An index name must be unique within a table and within a database.
Progress/SQL allows you to access existing Progress tables, fields, and variables even if their names contain characters that are not valid in Progress/SQL identifiers, such as hyphens and percent signs. You cannot, however, create new SQL tables and columns with these characters. Similarly, you cannot create new views and view columns with characters that are not valid in SQL identifiers. However, if the view columns are created implicitly with column names from the table, Progress/SQL allows you to retain the invalid characters.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |