Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DROP TABLE IF EXISTS t;
- BEGIN
- DROP TABLE t;
- EXCEPTION WHEN OTHERS THEN
- END;
- CREATE FUNCTION f_table_is_ok
- ( IN @table_name VARCHAR ( 128 ) )
- RETURNS INTEGER
- ON EXCEPTION RESUME
- BEGIN
- DECLARE @dummy INTEGER;
- EXECUTE IMMEDIATE STRING (
- 'SELECT TOP 1 1 INTO @dummy FROM ',
- @table_name,
- ' ORDER BY 1' );
- IF SQLSTATE IN ( '00000', '02000' ) THEN
- RETURN 1
- ELSE
- RETURN 0
- END IF;
- END;
- BEGIN
- DECLARE LOCAL TEMPORARY TABLE tt ( c INTEGER );
- DECLARE LOCAL TEMPORARY TABLE "t t" ( c INTEGER );
- SELECT f_table_is_ok ( 'asdf' );
- SELECT f_table_is_ok ( 'tt' );
- SELECT f_table_is_ok ( '"t t"' );
- SELECT f_table_is_ok ( '"SYS"."SYSTABLE"' );
- END;
Add Comment
Please, Sign In to add comment