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

7 votes264 views2 answers
Create mysql user
SQL
0 vote296 views2 answers
Oracle sql for each row
SQL
0 vote281 views1 answer
Dnsmasq.conf location macos
SQL
0 vote271 views1 answer
Version and edition of SQL Server Database Engine
SQL
0 vote279 views2 answers
MySQL top percent
SQL
0 vote270 views1 answer
Create domain sql
SQL
50 votes360 views6 answers
Sql duplicate rows
SQL
1 vote272 views10 answers
Stack overflow
SQL
0 vote286 views1 answer
Org.apache.spark.sql.avro.IncompatibleSchemaException: Unexpected type org.apache.spark.ml.linalg.VectorUDT
SQL
0 vote282 views1 answer
Use where instead of join
SQL