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.
