codenamejason/GetIndexes.sql

Created December 6, 2017 14:36

Star (1) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/codenamejason/2783ef432f3d320cf8411acce97d574d.js"></script>
Save codenamejason/2783ef432f3d320cf8411acce97d574d to your computer and use it in GitHub Desktop.

Download ZIP

Get the indexes for an object

Raw

GetIndexes.sql

	SELECT *
	FROM sys.indexes
	WHERE
	--name='YourIndexName' AND
	object_id = OBJECT_ID('<SCHEMA>.<TABLE>')

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment