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'


You May Interest

What are the Limitations of Indexed Views in SQL Server ?

Changing MS SQL Table Name with Query

MS SQL Get Current Time GETDATE()

What is TABLESAMPLE in SQL Server ?

Using CASE WHEN in MS SQL