avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Mar 29, 2016 at 08:50 AM

    Hi,

    Make sure option Quoted_Identfier is enabled (ON : by default  in dbisql and odbc connections).

    sp_iqcheckoptions;

    If off, enable it :

    Set temporary option QUOTED_IDENTIFIER='ON' ;

    drop "krish"."New Text Document" ;

    If still fais then display table information using query:

    sp_iqhelp "New Text Document";

    or

    select * from SYSTAB where lower(table_name) like '%new text document%'

    order by table_name ;

    Add comment
    10|10000 characters needed characters exceeded

Skip to Content