SybaseIQ: Drop Table with special character

154 Views Asked by At

I'm trying to delete a table named DBA.[ in Sybase IQ database. This is a wrong table which is not desired so we need to delete it. I've tried several options but not successful. Please share any workaround to drop the table, if anyone knows.

iqisql -Udba -P*** -Sdwhdb -w500

1> drop table dba.[
2> go

Msg 102, Level 15, State 0:
SQL Anywhere Error -131: Syntax error near '
' on line 2

1> drop table dba.[[]
2> go

Msg 102, Level 15, State 0:
SQL Anywhere Error -131: Syntax error near '[[' on line 1

1> drop table 'dba.[ '
2> go

Msg 102, Level 15, State 0:
SQL Anywhere Error -131: Syntax error near 'dba.[ ' on line 1

1> drop table dba.[
2> go

Msg 102, Level 15, State 0:
SQL Anywhere Error -131: Syntax error near '\' on line 1

1> drop table 'dba.[ '
2> go

Msg 102, Level 15, State 0:
SQL Anywhere Error -131: Syntax error near 'dba.[ ' on line 1

1> drop table 'dba.[[ '
2> go

Msg 102, Level 15, State 0:
SQL Anywhere Error -131: Syntax error near 'dba.[[ ' on line 1

1> drop table 'dba.['
2> go

Msg 102, Level 15, State 0:
SQL Anywhere Error -131: Syntax error near 'dba.[' on line 1

1> drop table 'dba.[['
2> go

Msg 102, Level 15, State 0:
SQL Anywhere Error -131: Syntax error near 'dba.[[' on line 1

1> drop table dba.[
2> go

Msg 102, Level 15, State 0:
SQL Anywhere Error -131: Syntax error near '\' on line 1

1> drop table dba.'[ '
2> go

Msg 102, Level 15, State 0:
SQL Anywhere Error -131: Syntax error near '[ ' on line 1

1> drop table dba.'[[ '
2> go

Msg 102, Level 15, State 0:
SQL Anywhere Error -131: Syntax error near '[[ ' on line 1

1> drop table dba.'[[] '
2> go

Msg 102, Level 15, State 0:
SQL Anywhere Error -131: Syntax error near '[[] ' on line 1

1> drop table dba.'[[] '
2> go

Msg 102, Level 15, State 0:
SQL Anywhere Error -131: Syntax error near '[[] ' on line 1

Table Name in Database

0

There are 0 best solutions below