Frank Kalis

SELECT
    OBJECTPROPERTY(O.[OBJECT_ID], 'CnstIsUpdateCascade') AS updcascade,
    OBJECTPROPERTY(O.[OBJECT_ID], 'CnstIsDeleteCascade') AS delcascade,
    [name]
FROM
    sys.objects O
WHERE
    OBJECTPROPERTY(O.[OBJECT_ID], 'IsForeignKey') = 1 AND
    (OBJECTPROPERTY(O.[OBJECT_ID], 'CnstIsUpdateCascade') = 1 OR OBJECTPROPERTY(O.[OBJECT_ID], 'CnstIsDeleteCascade') = 1)
ORDER BY 1 DESC, 3

DECLARE @TableID int
SELECT @TableID = OBJECT_ID ('Enter TableName here')

SELECT 
	OBJECT_NAME (IXStats.[object_id]) AS ObjectName,
    IXStats.index_type_desc,
    IXStats.avg_record_size_in_bytes
FROM 
    sys.dm_db_index_physical_stats (DB_ID(), @TableID, OBJECTPROPERTY (@TableID, 'TableHasClustIndex'), 0, 'SAMPLED') IXStats

Zum direkten Download geht es hier:

Ganze Geschichte »