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

1 vote367 views1 answer
Is sql fast
SQL
0 vote377 views1 answer
Psql get table data types
SQL
0 vote366 views1 answer
Sqlalchemy orm duplicate
SQL
0 vote363 views1 answer
Https://www.jitendrazaa.com/blog/sql/sqlserver/export-documents-saved-as-blob-binary-from-sql-server/
SQL
0 vote351 views1 answer
Sql bild in function
SQL
0 vote353 views1 answer
This week mysql
SQL
0 vote342 views1 answer
Mysql function variable
SQL
1 vote358 views1 answer
Mysql event last execution
SQL
0 vote331 views1 answer
Ms Sql set us timezone
SQL
3 votes341 views1 answer
Sql datetime as date
SQL