sp_MSForEachTable is a cool SP. It returns all the name of all Tables with the usage of a question mark "?". Is there anything else beside the usage with a question mark?
I did find this: https://www.sqlshack.com/an-introduction-to-sp_msforeachtable-run-commands-iteratively-through-all-tables-in-a-database/
Is there another one for columns?
Is there another one for other stuffs that I am not aware of?
Thanks