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

0 vote240 views1 answer
How we can perform acid Operations in sql with examples
SQL
0 vote225 views2 answers
T SQl Checking Your Username
SQL
0 vote229 views1 answer
Mysql loop through databases and execute query
SQL
12 votes256 views1 answer
Run mysql instance in docker
SQL
0 vote223 views1 answer
Select all tables linked server sql
SQL
0 vote229 views1 answer
Write sql query to show the details start from digit
SQL
0 vote225 views1 answer
Sql server udf performance
SQL
0 vote234 views1 answer
Insert set mysql
SQL
0 vote230 views1 answer
Delete * from where id = 1;
SQL
7 votes229 views2 answers
Oracle foreign key reference table
SQL