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

4 votes176 views2 answers
Postgresql float data type
SQL
0 vote148 views1 answer
Proc sql not in working
SQL
0 vote128 views1 answer
Faire une recherche par liste de mot clé sql
SQL
0 vote179 views1 answer
Mysql loop through databases and execute query
SQL
1 vote139 views2 answers
Mysql current user
SQL
0 vote149 views1 answer
Download sql file of countries names
SQL
19 votes145 views2 answers
Mysql tinyint max value
SQL
4 votes175 views1 answer
How to drop a database in sql server when it is in use
SQL
0 vote157 views1 answer
Sql last 3 rows
SQL
4 votes91 views1 answer
Generate class from sql table c#
SQL