How to list views, store procedures on a particular table in all databases.

Ruchika · #1 (**permalink**) 02-13-09, 07:45

Hi ,

I want to list down all the views, stor procs and functions made on a particular table. The search should not be confined to particular database.

gvee · #2 (**permalink**) 02-13-09, 07:49

What RDBMS are you using?

mike_bike_kite · #3 (**permalink**) 02-13-09, 07:54

Quote:

Originally Posted by Ruchika

Hi ,

I want to list down all the views, stor procs and functions made on a particular table. The search should not be confined to particular database.

That's nice. I want to build a small apartment on the cliffs of a little Greek island and overlooking the Aegean sea. Perhaps one day ...

blindman · #4 (**permalink**) 02-13-09, 09:27

Quote:

Originally Posted by mike_bike_kite

That's nice. I want to build a small apartment on the cliffs of a little Greek island and overlooking the Aegean sea. Perhaps one day ...

Hopefully it won't have internet access.

blindman · #5 (**permalink**) 02-13-09, 09:30

Ruchika, information about the tables and other objects in a database are typically stored in system tables. The names an structures of these system tables vary across database servers and versions. You should post your question in one of the subforums for the specific database engine you are using.

loquin · #6 (**permalink**) 02-17-09, 19:00

that being said, several vendors support the information_schema, including SQL Server (2005/2008), PostgreSQL, and MySQL

Internet Services

Web Development

Digital Marketing

Consumer Tech