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 votes160 views2 answers
REST API
SQL
0 vote155 views1 answer
Trigger stock phpmyadmin output message
SQL
8 votes141 views3 answers
Mysql alter table add index
SQL
1 vote178 views1 answer
Sql server loop over query
SQL
47 votes228 views6 answers
Add column mysql
SQL
1 vote169 views1 answer
Oracle compile schema
SQL
0 vote159 views1 answer
Alter check command
SQL
1 vote239 views1 answer
Mysql breakline on string
SQL
0 vote142 views1 answer
Json_remove mysql
SQL
2 votes110 views4 answers
Mysql change database character set to utf8mb4
SQL