We walk in the dark places no others will enter
We stand on the bridge and no one may pass

DECLARE @tblName sysname
SET @tblName = 'LargeTable'

SELECT name, type_desc FROM sys.indexes WHERE object_id = OBJECT_ID(@tblName)
SELECT name from sys.key_constraints where parent_object_id = OBJECT_ID(@tblName)

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

We walk in the dark places no others will enter
We stand on the bridge and no one may pass