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 vote203 views1 answer
Allow null in psql
SQL
0 vote178 views1 answer
Min:sec datediff mssql
SQL
4 votes217 views2 answers
Postgresql float data type
SQL
2 votes187 views4 answers
Sql query interview questions
SQL
0 vote201 views1 answer
Reindex mssql table
SQL
1 vote168 views1 answer
Order by oracle
SQL
6 votes200 views3 answers
Create database mysql utf8
SQL
2 votes169 views1 answer
Sqlplus clear screen
SQL
0 vote178 views1 answer
Sql count null values in all columns
SQL
12 votes199 views1 answer
Run mysql instance in docker
SQL