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 vote121 views1 answer
How convert into in in sql query
SQL
0 vote110 views1 answer
Mysql add root password
SQL
0 vote102 views1 answer
Python mysql query to dataframe
SQL
12 votes109 views1 answer
How to change the value of a table in sql
SQL
1 vote113 views1 answer
Connect to mysql database ubuntu
SQL
0 vote100 views1 answer
Como saber si tengo mysql instalado
SQL
1 vote96 views1 answer
Oracle aleter trigger ora-01031
SQL
1 vote96 views1 answer
Drush sql-dump
SQL
0 vote113 views1 answer
Add sqlcmd to path linux
SQL
0 vote99 views1 answer
Calculate age in sql
SQL