How to get list of all Entities Display Name, Logical Name and Other info using SQL Query in MSCRM?

Use the below query to get all the list of Entities Display Name, Logical Name and Object Type Code.

SELECT 
DISPLAYNAME.LABEL 'Display Name', 
EV.NAME 'Logical Name',
ObjectTypeCode 'Object Type Code'
FROM 
ENTITYVIEW EV INNER JOIN 
LOCALIZEDLABELLOGICALVIEW DISPLAYNAME
ON (EV.ENTITYID = DISPLAYNAME.OBJECTID) AND (DISPLAYNAME.OBJECTCOLUMNNAME = 'LOCALIZEDNAME')
WHERE 
LANGUAGEID = 1033 -- Add this if you want to filter records using language Id. For Example : LANGUAGEID 1033 is English
--AND ISCUSTOMENTITY = 1 -- Remove this if you want to show the system entities as well 
--AND ISACTIVITY = 0 -- Add this if you want to filter out the activity entity
--AND EN.NAME NOT LIKE '%MSDYN%' -- Add this if you want to remove like post album, filter, etc
ORDER BY 1

Output:

How to get list of all Entities Display Name, Logical Name and Other info using SQL Query in MSCRM

Inspired from Miss Dynamics CRM blog