Manjot
Manjot

Reputation: 11516

SQL server - schema

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

Answers (1)

Remus Rusanu
Remus Rusanu

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

Related Questions