Hello, On Donnerstag, 13. M�rz 2003 00:40, :: Jay Ramirez :: wrote: > Hi, > > I would like to know if SAP DB support SQL without the > "USER"."TABLE" reffering the tables? > > Like this: select * from "ADMIN2"."users" > Should be like this : select * from users > You might perhaps check the archives for stuff like this.
Something I posted a couple of days ago perfectly applies to your problem: Changing the default schema is supported in db2, e.g., but unfortunately not in sapdb. Alas, you have two other choices: 1. Log in as the user owning the schema. 2. Create synonyms for the tables. But you should keep in mind that if you have created the tables with quotation marks around the names, they are created case sensitive and you have to use the quotation marks for ever again to retain the correct case. "users" is not the same as "USERS" ans without quotes the database always sees a request for the latter. Peter Willadt _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
