Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2009
    Posts
    1

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

    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.

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    What RDBMS are you using?
    George
    Home | Blog

  3. #3
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    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 ...

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    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.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  5. #5
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    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.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  6. #6
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    that being said, several vendors support the information_schema, including SQL Server (2005/2008), PostgreSQL, and MySQL
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •