MSSQL query that gets all database tables. To get a list of all tables in a MSSQL database, you can use a SQL query to retrieve the table names from the system objects.
Source code viewer
SELECT name FROM sysobjects WHERE TYPE = 'u'Programming Language: SQL