Listing Metadata of MS SQL Server Internal Tables

178 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

What is The Difference Between The Index Seek and Index Scan in S ...

What is Service Broker in SQL Server ?

Which TCP/IP Port Does the SQL Server Run On ?

Making a Backup of MS SQL Database With Query

What are the Limitations of Indexed Views in SQL Server ?