Appendix › Useful Queries › Logical and Physical Names for all Entities

Logical and Physical Names for all Entities

Example: Query for returning the logical and physical names for all entities

SELECT TRAN(NAME) AS 'LOGICAL', TRAN(PHYSICAL_NAME) AS 'PHYSICAL'
FROM M0.ENTITY
ORDER BY 1

Back to Top