CREATE PROCEDURE dbo.showViews
AS
BEGIN
SET NOCOUNT ON

SELECT
ViewName = TABLE_NAME,
Owner = TABLE_SCHEMA,
SchemaBound = CASE
OBJECTPROPERTY(OBJECT_ID(TABLE_NAME), 'IsSchemaBound')
WHEN 1 THEN 'Yes'
WHEN 0 THEN 'No' END,
Indexed = CASE
OBJECTPROPERTY(OBJECT_ID(TABLE_NAME), 'IsIndexed')
WHEN 1 THEN 'Yes'
WHEN 0 THEN 'No' END
FROM
INFORMATION_SCHEMA.TABLES
WHERE
TABLE_TYPE = 'VIEW'
AND OBJECTPROPERTY(OBJECT_ID(TABLE_NAME), 'IsMsShipped') = 0
ORDER BY
TABLE_SCHEMA,
TABLE_NAME
END
GO

Regístrate y recibe un email semanal con los últimos trucos informáticos. Pulsa aquí!!

Este truco ha recibido 1 votaciones| Nota media: 7Selecciona tu Puntuación: