While you might view the source code using this SQL statement select proc_defn from sys.sysprocedure where proc_name = 'sa_table_page_usage'you won't get much information apart form the parameter declaration. System procedures call interal functions whose code isn't accessible. I appreciate your answer but i want to know the query behind the procedure call so then i can know which tables they are using.
(23 Jan '19, 04:42)
manvith
Comment Text Removed
I think that is different for different system procedures, some do contain their definition, others call internal procedures, and some do some stuff and then call internal procedures.
(23 Jan '19, 05:05)
Volker Barth
|
In addition to Reimer's answer, you may get more hints when searching within this forum, e.g. here is a discussion what the internal gear behind sa_table_fragmentation() might query: What is the Sybase Central 16 "Fragmentation" tab showing? Of course that usually won't answer what exact query the stored procedures perform if that is not contained within the SYSPROCEDURE's contents. Note, for sa_table_stats() and sa_table_fragmentation() the procedures's definitions is documented there - for the latter, at least partly. |