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

8 votes233 views1 answer
Similarities between ddl and dml
SQL
10 votes256 views3 answers
Sql limit results
SQL
0 vote267 views1 answer
Drop a field in psql django
SQL
14 votes293 views2 answers
Oracle add attribute to table
SQL
19 votes275 views6 answers
Sql create table
SQL
1 vote279 views1 answer
Oracle select first result
SQL
0 vote258 views1 answer
How to fetch highest score in minimum time using mysql
SQL
0 vote259 views1 answer
SQL Error 1040 : Too many connections
SQL
0 vote281 views1 answer
Import sql in postgresql
SQL
2 votes276 views1 answer
Oracle apex who is connected
SQL