Thanks Lily for correcting me!! :) On Tue, Aug 17, 2010 at 10:19 AM, Lily Wei <[email protected]> wrote:
> Hi there: > I believe it is legal for derby if you have delimiter around it. > > For example: > ij> create table "table.subtable.etc.notes" (a int); > 0 rows inserted/updated/deleted > ij> insert into "table.subtable.etc.notes" values (1); > 1 row inserted/updated/deleted > ij> select * from "table.subtable.etc.notes"; > A > ----------- > 1 > > 1 row selected > > However, due to reasons in turn of "." and keyword "table", I will > think twice in turn of the table name I end up choosing. > > > Hope this help, > Lily > > ------------------------------ > *From:* Nirmal Fernando <[email protected]> > *To:* [email protected] > *Sent:* Mon, August 16, 2010 9:04:55 PM > *Subject:* Re: invalid table name if too many dots (".") in it? > > Hi, > > As I can see "table.subtable.etc.notes" is not a valid table name for two > reasons: > > 1) You cannot use "." more than once. > 2) You cannot use "table.a" as a table name since it contains the word > "table" > > Hope this helps! > > > On Tue, Aug 17, 2010 at 9:11 AM, adhoc334 <[email protected]> wrote: > >> >> if i'm creating a table called table.subtable.etc.notes, would i get an >> error >> because there are too many dots in it? >> -- >> View this message in context: >> http://old.nabble.com/invalid-table-name-if-too-many-dots-%28%22.%22%29-in-it--tp29449214p29449214.html >> Sent from the Apache Derby Developers mailing list archive at Nabble.com. >> >> > > > -- > Best Regards, > Nirmal > > C.S.Nirmal J. Fernando > Department of Computer Science & Engineering, > Faculty of Engineering, > University of Moratuwa, > Sri Lanka. > > -- Best Regards, Nirmal C.S.Nirmal J. Fernando Department of Computer Science & Engineering, Faculty of Engineering, University of Moratuwa, Sri Lanka.
