List of tables in use by a view

Hot Topic

SQL Syntax
Unable to use Books Online search function
Can't connect to SQL Server 2005
Instead Of Trigger considerations for Multi-Row Insert
Selecting Connection in Custom Destination Component UI
Programmatically generating a reporting model??
How can I script object data in SMO?
MSSQL and .ASP pages
Unable to create SQL Server Mobile Subscription
Connection managers - OLE DB

SQL Server

Replication with fifteen subscriptions
Upsizing from Access 2000 to SQL Express 2005
CustomReportItem Installation
Problem with concurrent insert and update commands
Could anyone kindly tell me,What tool can I use to Create db or restore db or backup db in SQL 2005 Express?
Want Hyperlink to Open in a New Window
Express Manager for Sept CTP
SQL Server Management Studio Express: Missing DataBases from VWD Project
Analysis Services - Step by Step: Errors related to feature availability and configuration
SQL Server 2000 failed to attach database

List of tables in use by a view

Hi,

I wonder if I can list the tables (and views) used inside a view, I mean the list of tables in the FROM clause

Thanks,

Arty

Answer this question

List of tables in use by a view

  • Qwavel

    An easy way is to call the "sp_depends @objname" stored procedure. Within Management Studio, you can also right-click on an object and choose "View Dependencies"

    Peter



  • Mathieu Descorbeth

    One way is to use SMO like:

    Database db = srv.Databases["test"];

    string a = "sp_depends " + objname;

    db.ExecuteWithResults(a);


    There are other ways of using SMO to get the dependency information, but I do not have the code available.

    Peter

  • haus_baus

    I would like to do it inside VB.NET or C# using the SMO
  • List of tables in use by a view
Answer this question