Krishnamuthu
Reputation: 59
How to get list of stored procedure in a namespace of Caché database using a query?
How to get list of stored procedures available in a namespace from an Intersystems Caché database using query?
Upvotes: 0
Views: 468
Answers (2)
Stephen Canzano
Reputation: 326
You should be able to query the table
%sql_dict.routine
to obtain the information you are looking for.
Upvotes: 1
Related Questions
- Simple way to programmatically get all stored procedures
- List of Stored Procedure from Table
- List all stored procedures with schema name
- How to query Intersystems Caché for a list of namespaces, databases, and tables?
- Querying Intersystem Caché through ODBC
- How to use object script in a SQL Proc for an Intersystems Cache database
- Query returning all system stored procedures listed by MS SQL Server
- Sybase: get list of stored procedures using a particular table
- how to obtain a list of schemas in intersystems cache?
- How to Retrieve names of stored procedures in SQL Server?