List all tables in SQL Server database

Following SQL query gives you names of all the tables in the currently active database:

SELECT Name FROM Sys.Tables