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