Published on: 20 Feb, 2021

How to get all user-created tables in TSQL?

Tumblr Digg Google Plus

If you need to get all user-created tables in SQL server. You can use it by retrieving the table information under sys.Tables.

Here is the TSQL query to get the user-created tables in SQL Server.


SELECT  object_id, name, type_desc, create_date, modify_date
FROM sys.Tables
ORDER BY name

Comments

There are no comments available.

Write Comment
0 characters entered. Maximum characters allowed are 1000 characters.