We are using "sys.tables" system table to get list and details.
Here is the sql script.
SQL Query :
select * from sys.tables
|(To view original image , click on image)|
This is the very useful SQL Server Scripts.
Note : Give Us your valuable feedback in comments. Give your suggestions in this article so we can update our articles accordingly that.