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...
