Umbraco SQL query document types with properties

query_properties.sql

/****** Script for SelectTopNRows command from SSMS  ******/
SELECT TOP 1000 
  ct.pk,
	ct.alias as 'Content Type Alias',
	ct.icon as 'Content Type Icon',
	pt.alias as 'Property Alias',
	pt.Name as 'Property Name',
	data.propertyEditorAlias as 'Property Editor',
	data.dbType as 'Property DB Type',
	t.alias as 'Template Alias'
  FROM cmsContentType ct
left join [dbo].[cmsDocumentType] dt  on dt.contentTypeNodeId = ct.nodeId
left join cmsTemplate t on dt.templateNodeId = t.nodeId  
left join [cmsPropertyType] pt on ct.nodeId = pt.contentTypeId
left join [cmsDataType] data on data.[nodeId] = pt.[dataTypeId]

--where t.alias like 'ceo%'