Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @DBName VARCHAR(50)
- DECLARE @TableName VARCHAR(50)
- SET @DBName = 'Test_DB'
- SET @TableName = 'Test_DB.dbo.ExampleTable'
- SELECT DB_ID(@DBName) AS databaseID,
- @DBName AS databaseName,
- OBJECT_ID(@TableName) AS objectID,
- OBJECT_NAME(OBJECT_ID(@TableName), DB_ID(@DBName)) AS objectName,
- index_id AS indexID,
- name AS indexName,
- 1 AS exclusionMask
- FROM sys.indexes
- WHERE object_id = OBJECT_ID(@TableName)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement