ストアドプロシージャ

www.altova.com このトピックを印刷 前のページ 1つ上のレベル 次のページ

ホーム >  データベース構造の探索と変更 >

ストアドプロシージャ

ストアドプロシージャ can improve the performance of distributed applications by reducing the data traffic between server and client installations. Please note that you must register a stored procedure with the database before it can be called by a client program.

 

In DatabaseSpy, ストアドプロシージャ that are registered with the database are displayed in a separate folder in the オンラインブラウザー. A コンテキストメニュー provides several maintenance options and, 更に、 facilitates the creation of SQL statements for creating, altering, dropping, or executing the stored procedure (次を参照: SQL ステートメントの生成).

ob_procedures

DatabaseSpy provides sub-folders for the procedures where the parameters are displayed. The definitions can be edited and renamed in プロパティウィンドウ.

 

You can add ストアドプロシージャ to the favorites, rename, or delete them. When deleting a stored procedure, a データベース構造変更スクリプト is generated which must be executed in order for the deletion to take effect.


(C) 2019 Altova GmbH