check if table or stored procedure o trigger exist

In this forum we will discuss things relating the ZEOSLib 6.6.x stable versions

Moderators: gto, EgonHugeist

Post Reply
fcodebue
Junior Boarder
Junior Boarder
Posts: 32
Joined: 05.04.2008, 16:02
Contact:
Contact fcodebue

check if table or stored procedure o trigger exist

Post by fcodebue »

How I can check if table or stored procedure o trigger exist
there are some ideas...
Codebue Fabio
P-Soft - http://www.p-soft.biz
Firebird La Comunità Italiana - http://www.firebirdsql.it
GestionaleOpen - http://www.gestionaleopen.org
Top
seawolf
Zeos Dev Team *
Zeos Dev Team *
Posts: 385
Joined: 04.06.2008, 19:50
Contact:
Contact seawolf

Post by seawolf »

ZConnection.GetTableNames('',list) where list is a TStrings containing a list of all tables (system tables too).
ZConnection.GetStoredProcNames('',list) where list is a TStrings containing a list of all stored procedures.
Top
fcodebue
Junior Boarder
Junior Boarder
Posts: 32
Joined: 05.04.2008, 16:02
Contact:
Contact fcodebue

Post by fcodebue »

seawolf wrote:ZConnection.GetTableNames('',list) where list is a TStrings containing a list of all tables (system tables too).
ZConnection.GetStoredProcNames('',list) where list is a TStrings containing a list of all stored procedures.
and how to discover a trigger?
Codebue Fabio
P-Soft - http://www.p-soft.biz
Firebird La Comunità Italiana - http://www.firebirdsql.it
GestionaleOpen - http://www.gestionaleopen.org
Top
Post Reply

Return to “6.6 - stable”