Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to drop a table name like "New Text Document" in sybase iq 16sp08 ?

In our organization we have to drop some schemas for that we have to drop all the tables and sp's  of those schemas, we have a problem here one table

like "New Text Document" exist in one schema we are unable to  drop this table, when we try to drop it says table does not exist. But it exits it systab output. So we are unable to drop a schema now.

I tried this statements

drop table "New Text Document";

drop table "krish.New Text Document"

drop table 'krish.New Text Document'

drop table 'New Text Document';

we are unable select this table also.

thanks in advance

Regards

Krishnam Raju.P

Tags:
Former Member
replied

Sorry for the mistyping. Add keyword table :

drop table "krish"."New Text Document" ;

I tested  commands below with success:

create table "new testtable demo" (col1 int, col2 varchar(20)) ;

sp_iqtable "new testtable demo" ;

Result:

Table_name,Table_type,Table_owner,Server_type,location,dbspace_id,isPartitioned,Remarks,table_constraints,PartitionType,isRlv 'new testtable demo','BASE','DBA','IQ','Main',16384,'N',,,'None','F'

drop table "DBA"."new testtable demo"

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question