Home / Questions / 69415
Accepted
Jose Yeste
Asked: 2020-05-13 00:15:25 +0800 CST 2020-05-13 00:15:25 +0800 CST

Know with which tables a view was created, SQL Server [closed]

  • 772

I am analyzing a database and there is a view that I don't know where it gets the information from, is there any statement to know where the view gets the data from?

sql

1 Answers

  1. Best Answer

    Enter from SQL Server to the DB you want to look at and in the views section look for the one that interests you. Right-click on it and in the drop-down that appears click Design.

    A view editing window will be displayed where the tables used will also appear, as well as the query used to generate that view.

    EDIT: In case you want to obtain the query through a query from SQL 2005 you can obtain it in this way:

    SELECT definition
FROM sys.objects o
JOIN o.object_id = object_id('dbo.Nombre_DE_La_Vista') and o.type = 'V'
    • 0