dbTalk Databases Forums  

Renaming Table in SCJIEW

sybase.public.sqlanywhere.general sybase.public.sqlanywhere.general


Discuss Renaming Table in SCJIEW in the sybase.public.sqlanywhere.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Robert Paresi
 
Posts: n/a

Default Renaming Table in SCJIEW - 11-02-2009 , 11:46 AM






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

Reply With Quote
  #2  
Old   
Glenn Paulley [Sybase iAnywhere]
 
Posts: n/a

Default Re: Renaming Table in SCJIEW - 11-02-2009 , 12:05 PM






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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.