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 😎.

Komentar

Postingan populer dari blog ini

Bagian-bagian Browser

kebiasaan menghapus kontak

Cara Build PHP 7.4.0alpha1 Dari Source Code Pada Ubuntu 16.04 LTS

Referensi "Ni No Kuni: Cross Worlds"