sys.tables lists all user tables from a single database, But it doesn't have their schema name.
If I know existing databases when creating the code, I can use
USE to browse all databases, query
sys.tables for its tables, and insert the list into a temptable to use later.
But, is there an easier way to do it, and with a unique query be able to retrieve all user tables from all user databases with their schema?