Blog Post

Find all views created on a table

,

USE ADVENTUREWORKS; -- You can use any kind of database that you have
GO

--Procedure that shows all views created on a table, together with schema

CREATE PROCEDURE VIEWS_IN_TABLE
@TABLENAME
VARCHAR(200)
AS
SELECT
VIEW_SCHEMA, VIEW_NAME FROM INFORMATION_SCHEMA.VIEW_TABLE_USAGE
WHERE TABLE_NAME = @TABLENAME;
GO

--executing the procedure with parameter value
EXEC VIEWS_IN_TABLE
ADDRESS

--n'joy the results!

--Dugi

 

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating