Changes to identifiers

In Sybase IQ 15.0, rules for identifiers have changed as follows:

• Table names can no longer contain double quote characters.

• User names and database names can no longer contain double quote characters, single quote, and semicolon characters.

• User names and database names may no longer start with a space or end with a space.

• Dbspace names are no longer case sensitive in a CASE RESPECT database. For example, the second command below now fails with the error “Item 'main2' already exists”:

  CREATE DBSPACE MAIN2 AS 'main_file2' IQ STORE 10;
  CREATE DBSPACE main2 AS 'main_file3' IQ STORE 10;