SELECT name AS table_name,SCHEMA_NAME(schema_id) AS schema_name,type_descFROM sys.objectsWHERE type_desc LIKE '%User_Table%';
Login to post response