Guest User

Untitled

a guest
Jul 15th, 2018
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.84 KB | None | 0 0
  1. CREATE TABLE dbo.TestCluster
  2. (
  3. TestClusterID INT NOT NULL
  4. );
  5.  
  6. CREATE CLUSTERED INDEX CX_TestCluster --note there is no "UNIQUE" keyword here
  7. ON dbo.TestCluster(TestClusterID);
  8.  
  9. SELECT SchemaName = s.name
  10. , TableName = o.name
  11. , IndexName = i.name
  12. , IndexType = i.type_desc
  13. , IsUnique = i.is_unique
  14. FROM sys.indexes i
  15. INNER JOIN sys.objects o ON i.object_id = o.object_id
  16. INNER JOIN sys.schemas s ON o.schema_id = s.schema_id
  17. WHERE s.name = 'dbo'
  18. AND o.name = 'TestCluster'
  19. AND i.type_desc = 'CLUSTERED';
  20.  
  21. SELECT OBJECT_NAME(object_id) AS TableName ,
  22. name AS IndexName ,
  23. type_desc AS IndexType ,
  24. CASE WHEN is_unique = '1' THEN 'UNIQUE'
  25. WHEN is_unique = '0' THEN 'NON UNIQUE'
  26. END AS Index_Desc
  27. FROM sys.indexes
  28. WHERE type_desc = 'CLUSTERED'
  29. AND OBJECT_NAME(object_id) = 'MyTable';
Add Comment
Please, Sign In to add comment