SMS SQL to view the Database Schema
Microsoft doesn't support direct access to the SMS Database, however from time to time you may need to query the db directly from SQL. To view the schema, the following SQL comes in handy.
---- Begin SQL----
--This query will show all the views in the SMS db
SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.VIEWS
WHERE TABLE_SCHEMA = 'dbo'
----End SQL----
---- Begin SQL----
--This query will show all the views in the SMS db
SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.VIEWS
WHERE TABLE_SCHEMA = 'dbo'
----End SQL----
Comments