Find Views SchemaBinding
25-Nov-0909 Leave a comment
Other ways exist. For instance in code.
CREATE
PROCEDURE [dbo].[uspViewsSchemaBound](@DatabaseName nvarchar(50))
AS
DECLARE
@SQL nvarchar(200)SET @SQL = ‘SELECT * FROM ‘ + @DatabaseName + ‘.INFORMATION_SCHEMA.VIEWS WHERE VIEW_DEFINITION LIKE ”%WITH SCHEMABINDING%”’
EXECUTE (@SQL)
Stephen Shakespeare 