Today I have to get a list of all tables present in database. I used following query to get the list of all tables present in SQL Server Database.

SELECT TABLE_NAME  
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' order by TABLE_NAME