Skip to content

Instantly share code, notes, and snippets.

@timgaunt

timgaunt/gist:5542813

Created May 8, 2013 19:09
Show Gist options
  • Save timgaunt/5542813 to your computer and use it in GitHub Desktop.
Save timgaunt/5542813 to your computer and use it in GitHub Desktop.
Download ZIP
List Umbraco DataTypes
Raw
gistfile1.sql
SELECT
dt.controlId,
n.UniqueId,
n.text,
dt.dbType
FROM dbo.umbracoNode n
LEFT JOIN dbo.cmsDataType dt
ON n.id = dt.nodeId
WHERE dt.nodeId IS NOT NULL
ORDER BY n.text
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment