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

11 votes188 views5 answers
Sql server reset identity
SQL
0 vote183 views1 answer
Sql bild in function
SQL
1 vote191 views2 answers
Postgresql check privileges on schema
SQL
17 votes176 views5 answers
Order by sql
SQL
0 vote274 views1 answer
Postgresql powershell query
SQL
3 votes189 views2 answers
Order by postgresql
SQL
0 vote149 views1 answer
Count column of tables psql
SQL
0 vote177 views1 answer
Sql server bool select
SQL
15 votes181 views4 answers
Create table if not exists sql
SQL
0 vote166 views1 answer
Mysql delete from where like
SQL