Page 1 of 1

check if table or stored procedure o trigger exist

Posted: 01.07.2009, 14:14
by fcodebue
How I can check if table or stored procedure o trigger exist
there are some ideas...

Posted: 01.07.2009, 21:44
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.

Posted: 01.07.2009, 23:03
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?