Listing Metadata of MS SQL Server Internal Tables
In MS SQL Server, internal tables are created as a by-product of a user action and are often inaccessible. Data in internal tables cannot be changed. However, the metadata of the internal tables can be viewed using the following query.
SELECT * FROM Sys.Objects WHERE Type='IT'