System Stored Procedure sys.sp_tables

I have seen people running the following script quite often, to know the list of the tables from the database:SELECT *FROM sys.tablesGOThe script above provides various information from create date to file stream, and many other important information. If you need all those information, that script is the one for you. However, if you do not need all those information, I suggest that you run the