Each database object must have a unique name within a certain name space. Outside this name space, duplicate names are allowed. Some database objects occupy different name spaces in Adaptive Server Enterprise as compared to Adaptive Server Anywhere and IQ.
Table name uniqueness requirements are within a database:
For IQ and Anywhere, table names must be unique within a database for a given owner. For example, both user1 and user2 can create a table called employee; uniqueness is provided by the fully qualified names, user1.employee and user2.employee.
For Adaptive Server Enterprise, table names must be unique within the database and to the owner.
Index name uniqueness requirements are within a table. In all three products, indexes are owned by the owner of the table on which they are created. Index names must be unique on a given table, but any two tables may have an index of the same name, even for the same owner. For example, in all three products, the tables t1 and t2 may have indexes of the same name, whether they are owned by the same or different users.
Sybase IQ lets you rename explicitly created indexes, foreign key role names of indexes, and foreign keys, using the ALTER INDEX statement. Adaptive Server Anywhere lets you rename indexes, foreign key role names, and foreign keys, using the ALTER INDEX statement. Adaptive Server Enterprise does not allow you to rename these objects.
