>How can you get the structure of table(s)/view(s) to do something in your application layer if you have only SPs provided by a DBA? Documentation only?
>
>Cetin,
>
>This can be accomplished quite easily by an SP that hits the INFORMATION_SCHEMA. I have one that does all sorts of lookups to get me information. Again, think of it as API based...
>
>Kevin

Kevin,
It's not so easy especially when INFORMATION_SCHEMA are diminishing and an SP might return anything like multiple result sets, do an action first that affect many tables then return something, return different things based on parameters etc.
Cetin