Home Forums SQL Server 2005 T-SQL (SS2K5) How to list the source table name of columns in a VIEW (SQL Server 2005) RE: How to list the source table name of columns in a VIEW (SQL Server 2005)

  • Have a look in INFORMATION_SCHEMA.VIEW_COLUMN_USAGE for the view-related info - you may have to join that to another i_s view to get everything you want.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.