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

2 votes158 views1 answer
Drop table purge
SQL
0 vote166 views1 answer
How to print mysql query of codeigniter query builder
SQL
0 vote188 views1 answer
Add column in sql server ubuntu
SQL
2 votes211 views2 answers
Asp.net core with postgresql deploy on ubuntu
SQL
2 votes181 views1 answer
Drop all foreign key constraints mysql
SQL
1 vote161 views1 answer
Sql select all from one table and one column from another
SQL
7 votes174 views4 answers
Index in mysql
SQL
0 vote167 views1 answer
Sql row number in result set
SQL
0 vote194 views1 answer
Mysqlimport
SQL
8 votes166 views2 answers
Phpmyadmin default password
SQL