jamescoxhead/UmbracoUnusedDatatypes.sql

Last active November 23, 2016 12:59

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

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

Download ZIP

Lists Umbraco datatypes which haven't been used on document types. Care is needed if using packages like Archetype as this script will show datatypes as unused if they are only used on an archetype.

Raw

UmbracoUnusedDatatypes.sql

	SELECT distinct [nodeId]
	FROM [cmsDataType]
	EXCEPT
	SELECT distinct dataTypeId
	FROM [cmsPropertyType]

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