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

16 votes149 views2 answers
Sql vs nosql
SQL
0 vote101 views2 answers
Sql update from two different database
SQL
2 votes132 views1 answer
Cast string to datetime mysql
SQL
0 vote133 views1 answer
How to check xampp mysql password
SQL
11 votes311 views4 answers
Round in sql
SQL
2 votes136 views2 answers
Storing timezones in postgres
SQL
1 vote130 views1 answer
Wherein mysql
SQL
0 vote133 views1 answer
Oracle remove line breaks
SQL
4 votes160 views1 answer
Postgresql change default value
SQL
1 vote137 views1 answer
Increase existing date in sql
SQL