Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Dukagjin Maloku - Dugi'DBA

Everything that I can post for the SQL Server ...

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

 

Comments

No comments.

Leave a Comment

Please register or log in to leave a comment.