Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Command line to list procedures and veiw in Database
- Thread starter steverb
- Start date
delphIBase
Programmer
You can use
SELECT RDB$PROCEDURE_NAME from RDB$PROCEDURES to view the name of all the procedures in the database and
SELECT RDB$VIEW_NAME from RDB$VIEW_RELATIONS to view the name of all the view in the database
You may need admin preveleges to execute the aforementioned staments though.To know more about system tables please refer to INTERBASE LANGUAGE REFERENCE.
SELECT RDB$PROCEDURE_NAME from RDB$PROCEDURES to view the name of all the procedures in the database and
SELECT RDB$VIEW_NAME from RDB$VIEW_RELATIONS to view the name of all the view in the database
You may need admin preveleges to execute the aforementioned staments though.To know more about system tables please refer to INTERBASE LANGUAGE REFERENCE.
- Status