Listing Metadata of MS SQL Server Internal Tables

210 Reads Ms Sql

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'
Ms Sql

You May Interest

Getting List of System Hard Disks with Free Space in MS SQL Serve ...

What are Some Advantages of Using CTE in SQL Server ?

Generating Random Letters in MS SQL

MS SQL Getting List of All Column Names of a Table

What is the Difference Between Clustered and a Non-clustered Inde ...