Tomita SERBAN wrote: > select * from user1.table1 - don't work > and > select * from "user1"."table1" - work > > I need to work without first sintax.
First of all: the whole list prefers mails which tell in the subject-line the subject, this mail deals with. If you are forced to read a lot of mails it is much easier to decide which are of any interest for YOU, if the subject is given not only in the mail itself. Thank you to all of you which use the subject-line in this way. Second: usually it is much easier to help, if not only 'it does not work' is provied as info, but if the reaction, the errormessage, at least the errornumber, is provided. In this case it was easy to imagine what the errornumber could have been, but in many other cases we have to guess what may have happened (and may guess wrong). Thank you to all of you giving us detailled info. To the question itself: identifier given as simple_identifier (without double quotes) are NOT case-sensitive. They are always mapped to UPPER case. Identifier given with double quotes are stored as they are. ==> if you use double quotes when you create an object (user/table/column) and the identifier includes at least one small character, then you have to use the double quotes always. that means, you created your table and user using double quotes. Now you have to use them all the time ( or drop them and recreate them without double quotes). Pay attention that all user - data will be lost, if you drop the user. Elke SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
