Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Query to return stored procedure into
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
Query to return stored procedure into
Divers
Thread ID:
00742008
Message ID:
00742008
Vues:
54
Hi,

I have to do some documentation on one of our systems that has over 100 stored procedures (excluding the system SP's).

I'd like to write a query that will give the the SP name, table dependencies, input/output parameters and datatypes.

My question is this: Should I query the system tables directly or use the Information Schema Views? If anyone already has a query that generates results similiar to what I'm looking for - would it be possible to post the query you used?

Thanks,

Al
Al Williams

Anola MB, CANADA
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform