Hi Wolfgang,
> It seems you created the table m with quotes.
>If you used the Table Definition Dialog of SQL Studio you should check
>the upper case option.
No I do not use the table definition dialog to create
tables.This table "m" was a table of mine called "calldetailrecord" that
was somehow renamed to "m". I have no idea how/why this happened.
> Please check if you have any filter (which is case sensitive) for the
>catalog tree.
I am unaware of these "filters" you speak of. How can I set up a
filter?? Is there a default filter??
Regards,
Ajit
-----Original Message-----
From: Auer, Wolfgang [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 22, 2005 7:01 PM
To: Ajit Aranha
Subject: RE: Table sizes -a unknown table is the largest
Hello Ajit,
It seems you created the table m with quotes.
If you used the Table Definition Dialog of SQL Studio you should check
the upper case option.
Please check if you have any filter (which is case sensitive) for the
catalog tree.
Regards
Wolfgang
-----Original Message-----
From: Ajit Aranha [mailto:[EMAIL PROTECTED]
Sent: Dienstag, 22. Februar 2005 11:43
To: Auer, Wolfgang
Cc: Zabach, Elke; [email protected]
Subject: RE: Table sizes -a unknown table is the largest
Hi Wolfgang,
SQLStudio version is 7.4.3.3
Select * from tables where tablename='m' returns:
OWNER TABLENAME PRIVILEGES TYPE TABLETYPE
CREATEDATE CREATETIME UPDSTATDATE UPDSTATTIME
ALTERDATE ALTERTIME UNLOADED SAMPLE_PERCENT
SAMPLE_ROWS COMMENT TABLEID
ONMOBILE m SEL+UPD+DEL+INS+REF+IND+ALT+ TABLE TABLE
2003-08-19 21:32:15 2003-08-19 21:32:15
2004-07-14 13:31:11 NO ?
20000 ? 00000000000002C0
I noticed that the tablename m is in lowercase,while other tablenames
are in uppercase in the "table" view
Also select * from onmobile.m does not work. (says unknown tablename m.
Yes I am connected as the user ONMOBILE)
Select * from m works however.
Regards,
Ajit
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
