Schema-Vergleich
| ID | 158 |
|---|---|
| Link Reference | Not set |
| Link Credits | Not set |
| Link Technical Documentation | Not set |
| PlCodelang | T-SQL |
| PlGroup | Datenbank |
| PlItemTitle | Schema-Vergleich |
| Code | SELECT * FROM ( SELECT TABLES_P.TABLE_SCHEMA AS [SCHEMA_P] , TABLES_P.TABLE_NAME AS [OBJECTNAME_P] , TABLES_P.TABLE_TYPE AS [OBJECTTYPE_P] FROM <DATABASE_PRODUCTION>.INFORMATION_SCHEMA.TABLES AS TABLES_P UNION ALL SELECT ROUTINES_P.ROUTINE_SCHEMA AS [SCHEMA_P] , ROUTINES_P.ROUTINE_NAME AS [OBJECTNAME_P] , ROUTINES_P.ROUTINE_TYPE AS [OBJECTTYPE_P] FROM <DATABASE_PRODUCTION>.INFORMATION_SCHEMA.ROUTINES AS ROUTINES_P UNION ALL SELECT '' AS [SCHEMA_P] , TRIG.name AS [OBJECTNAME_P] , 'TRIGGER TABLE' AS [OBJECTTYPE_P] FROM <DATABASE_PRODUCTION>.sys.triggers AS TRIG INNER JOIN <DATABASE_PRODUCTION>.sys.tables AS TAB ON TRIG.parent_id = TAB.object_id UNION ALL SELECT '' AS [SCHEMA_P] , TRIG.name AS [OBJECTNAME_P] , 'TRIGGER VIEW' AS [OBJECTTYPE_P] FROM <DATABASE_PRODUCTION>.sys.triggers AS TRIG INNER JOIN <DATABASE_PRODUCTION>.sys.views AS TAB ON TRIG.parent_id = TAB.object_id ) ss_P FULL OUTER JOIN ( SELECT TABLES_E.TABLE_SCHEMA AS [SCHEMA_E] , TABLES_E.TABLE_NAME AS [OBJECTNAME_E] , TABLES_E.TABLE_TYPE AS [OBJECTTYPE_E] FROM <DATABASE_DEVELOPMENT>.INFORMATION_SCHEMA.TABLES AS TABLES_E UNION ALL SELECT ROUTINES_E.ROUTINE_SCHEMA AS [SCHEMA_E] , ROUTINES_E.ROUTINE_NAME AS [OBJECTNAME_E] , ROUTINES_E.ROUTINE_TYPE AS [OBJECTTYPE_E] FROM <DATABASE_DEVELOPMENT>.INFORMATION_SCHEMA.ROUTINES AS ROUTINES_E UNION ALL SELECT '' AS [SCHEMA_P] , TRIG.name AS [OBJECTNAME_P] , 'TRIGGER TABLE' AS [OBJECTTYPE_P] FROM <DATABASE_DEVELOPMENT>.sys.triggers AS TRIG INNER JOIN <DATABASE_DEVELOPMENT>.sys.tables AS TAB ON TRIG.parent_id = TAB.object_id UNION ALL SELECT '' AS [SCHEMA_P] , TRIG.name AS [OBJECTNAME_P] , 'TRIGGER VIEW' AS [OBJECTTYPE_P] FROM <DATABASE_DEVELOPMENT>.sys.triggers AS TRIG INNER JOIN <DATABASE_DEVELOPMENT>.sys.views AS TAB ON TRIG.parent_id = TAB.object_id ) ss_E ON ss_P.[SCHEMA_P]=ss_E.[SCHEMA_E] AND ss_P.OBJECTNAME_P=ss_E.OBJECTNAME_E AND ss_P.OBJECTTYPE_P=ss_E.OBJECTTYPE_E |
| Result Example |