Sql anywhere create procedure

CREATE TEMPORARY PROCEDURE drop_table( IN @TableName char(128) )
BEGIN
    IF EXISTS  ( SELECT * FROM SYS.SYSTAB WHERE table_name = @TableName ) THEN
   EXECUTE IMMEDIATE 'DROP TABLE "' || @TableName || '"';
   MESSAGE 'Table "' || @TableName || '" dropped' to client;
    END IF;
END;
CALL drop_table( 'CustRank' );

Source: dcx.sybase.com

Similar codes

1 vote124 views2 answers
DROP TABLes regardless of constraints
SQL
0 vote166 views1 answer
Alter domain sql
SQL
0 vote189 views1 answer
Selecting from a view SQL
SQL
-1 vote149 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
0 vote158 views1 answer
SQL joins in python
SQL
0 vote148 views1 answer
Alter check command
SQL
0 vote140 views3 answers
Condition in count sql
SQL
0 vote127 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL
9 votes151 views3 answers
Import DB through mysql console
SQL
0 vote203 views1 answer
Mysql update all record removing 2 hours from column
SQL