RE: Table Names need ""

[Zabach, Elke]

Ian wrote:   > I imported an SQL Server database and data into sap but all my queries > require " (quotes) around the table name and column names.. > > So I figured it out, its because they are mixed case, if I edit the > TABLE names and COLUMN names and put them to upper case it works without problems. > > So I do I change all my tables so that the COLUMN names are are set to UPPER CASE?? > > Please help, getting desperate, I am so close but yet so far, <grin>..... > As written in the reference manual:   Simple identifier  Simple identifier. The first character in a simple identifier must not be a digit or underscore. Syntax <simple_identifier> ::= <first_character>[<identifier_tail_character>...] first_character, identifier_tail_character Explanation Simple identifiers are always converted into uppercase characters in the database. For this reason, simple identifiers are not case sensitive. If the name of a database object is to contain lowercase letters, special characters, or blanks, the identifier must be specified as a special identifier (in double quotes).    -->  If you do not want to use " " around all names, you are not allowed to use them during creation of an object (if you use other character than capital letter and those 3 special character allowed for simple_identifier). Therefore: check how the tables are created and try to avoid using " there.   Elke SAP Labs Berlin