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:[EMAIL PROTECTED] > Sent: Tuesday, February 22, 2005 1:53 PM > To: Ajit Aranha > Cc: [email protected] > 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:[EMAIL PROTECTED] > > Sent: Monday, February 21, 2005 1:33 PM > > To: Ajit Aranha; [email protected] > > 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/[EMAIL PROTECTED]
