How to get list of tables in Database TSQL

You can use the list down all tables in specific database with this query

select TABLE_NAME from information_schema.tables where Table_Type = 'BASE TABLE'