To list all tables in a SQL Server database using a query, you can leverage the system views provided by SQL Server. The most common and recommended approach involves querying the INFORMATION_SCHEMA.TABLES view or the sys.tables and sys.schemas system views.