Perintah "RECREATE PROCEDURE" FirebirdSQL
I just known, that Firebird have DDL (Data Definition Language) for DROP+CREATE store procedure in one go.
so instead of
"CREATE PROCEDURE test; ALTER PROCEDURE test;"
or
"DROP PROCEDURE test; CREATE PROCEDURE test;"
you can just
"RECREATE PROCEDURE test;" and boom! done 😎.
"CREATE PROCEDURE test; ALTER PROCEDURE test;"
or
"DROP PROCEDURE test; CREATE PROCEDURE test;"
you can just
"RECREATE PROCEDURE test;" and boom! done 😎.
Komentar
Posting Komentar
Komentar ...