AW: Table sizes -a unknown table is the largest

Ajit Aranha wrote:
> 
> Hi Elke,
>       FYI the table "calldetailrecord" is one of mine. I don't know
> why/how it got renamed to "m". What is strange is the table "m" does
not
> appear in SQLStudio's list of tables.
> 
>       Can you tell me in what case a table does not appear in the
> SQLStudio's list of tables even when it exists for the connected
user??

Hope, this will be answered by a SQLStudio-guy.

> Also is it possible to rename a table via SQL queries or from
> SQLstudio??

As you can see in the reference manual:

Data-definition--> rename table

http://dev.mysql.com/doc/maxdb/en/6d/117c1dd14811d2a97400a0c9449261/fram
eset.htm

Elke
SAP Labs Berlin

> Thanks and Regards,
> Ajit
> 
> -----Original Message-----
> From: Zabach, Elke [mailto:elke.zabach@xxxxxxx]
> Sent: Tuesday, February 22, 2005 1:53 PM
> To: Ajit Aranha
> Cc: maxdb@xxxxxxxxxxxxxxx
> Subject: AW: Table sizes -a unknown table is the largest
> 
> Ajit Aranha wrote:
> >
> > Hi Elke,
> >     Yes I am able to select from it despite it not appearing in
> > sqlstudio.
> > I have determined that the table "m" contains data from a table
called
> > "calldetailrecord" which seems to have gone missing in sqlstudio (I
> > can't even query from it).
> 
> Noone within MaxDB-development knows this table calldetailrecord.
> Therefore we cannot help.
> During dropping / deleting a/from a table, that table is not renamed,
> neither to "m", nor to another name.
> 
> Sorry, but we will not be able to help finding out why this funny
table
> existed so far.
> 
> Elke
> SAP Labs Berlin
> 
> >  Is it possible that somehow as part of a drop table/delete all rows
> > operation in sqlstudio the table got renamed?
> > Also why would this table "m" not appear in SQLStudio but select *
> from
> > "m" still work?
> >     Luckily this table contains non crucial data and I can delete
> > it. Any clues on the likely cause of this table "calldetailrecord"
> > having being renamed and not appearing in SQLstudio will be much
> > appreciated.
> > Regards,
> > Ajit
> >
> > -----Original Message-----
> > From: Zabach, Elke [mailto:elke.zabach@xxxxxxx]
> > Sent: Monday, February 21, 2005 1:33 PM
> > To: Ajit Aranha; maxdb@xxxxxxxxxxxxxxx
> > Subject: AW: Table sizes -a unknown table is the largest
> >
> > Ajit Aranha wrote:
> > >
> > > Hi,
> > > While estimating the number of pages used by tables in SAPDB
> 7.3.0.48
> > > I get the largest table with name m and   Used  pages   112159 .
> This
> > is
> > > not a table created by me, and it does not appear in SQLSTudio.
What
> > is
> > > his table??
> >
> > MaxDB/SAP DB does not create such table either: tablename one small
!
> > letter, never used as pre-defined tablename
> >
> > Which owner is given for this table? Are you able to select that
table
> > (if given as m you have to do a select * from "m") ?
> >
> > Elke
> > SAP Labs Berlin
> >
> > > Regards,
> > > Ajit
> > > P.S.
> > > I am getting table size using dataextract * from TABLESTATISTICS
> WHERE
> > > Description = 'Used  pages' and owner='XYZ'
> 


--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx