Reputation: 11516
We can see schema for all tables and views by:
SELECT * FROM INFORMATION_SCHEMA.TABLES
SELECT * FROM INFORMATION_SCHEMA.VIEWS
Can we view schema for stored procedures or functions through tsql?
Upvotes: 0
Views: 165
Reputation: 294277
In other Information Schema Views, like INFORMATION_SCHEMA.ROUTINES
:
Returns one row for each stored procedure and function that can be accessed by the current user in the current database
Upvotes: 4