Tables beginning with # (temporary tables)  Uniqueness of object names

Chapter 4: Expressions, Identifiers, and Wildcard Characters

Case sensitivity and identifiers

Sensitivity to the case (upper or lower) of identifiers and data depends on the sort order installed on your Adaptive Server. Case sensitivity can be changed for single-byte character sets by reconfiguring Adaptive Server’s sort order; see the System Administration Guide for more information. Case is significant in utility program options.

If Adaptive Server is installed with a case-insensitive sort order, you cannot create a table named MYTABLE if a table named MyTable or mytable already exists. Similarly, the following command will return rows from MYTABLE, MyTable, or mytable, or any combination of uppercase and lowercase letters in the name:

select * from MYTABLE




Copyright © 2005. Sybase Inc. All rights reserved. Uniqueness of object names

View this book as PDF