Schema names are always case-insensitive, whether or not the database
has case-sensitive or case-insensitive string comparisons. As far as I
know all RDBMS products work that way, as that behaviour is stipulated
in the SQL standard.
Glenn
Robert Paresi wrote:
Quote:
Hello,
Changing the name of a table from "Reports" to "REPORTS" says it can't
be done because table already exists.
Workaround is to rename it to REPORTS2 and then REPORTS
-Robert |
--
Glenn Paulley
Director, Engineering (Query Processing)
Sybase iAnywhere
Blog: http://iablog.sybase.com/paulley
EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all
To Submit Bug Reports: http://case-express.sybase.com
SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288
Whitepapers, TechDocs, and bug fixes are all available through the
Sybase iAnywhere pages at
http://www.sybase.com/products/datab...chnicalsupport