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 votes330 views2 answers
Mamp connect mysql terminal
SQL
0 vote322 views1 answer
Inner join distinct
SQL
14 votes368 views5 answers
Set password for postgres user ubuntu
SQL
0 vote338 views1 answer
Oracle query archive mode
SQL
9 votes345 views3 answers
Date format in sql
SQL
0 vote349 views1 answer
Sql query to force the database to be drop
SQL
12 votes320 views2 answers
Delete entries in postgresql
SQL
0 vote326 views1 answer
Sql comand for removing data from table
SQL
0 vote321 views1 answer
Mysql workbench indent formatting
SQL
4 votes323 views1 answer
Sql quote in string
SQL