This tutorial shows you how to use commands to list all tables of a specified database in MySQL, PostgreSQL, Oracle, SQL Server, DB2, and SQLite.

Adding WHERE TABLE_TYPE='BASE TABLE' will include only base tables (and by extension you could always use WHERE TABLE_TYPE != 'VIEW'). "sysdiagrams" appears in this list too : ( sysdiagrams …

Mar 4, 2021 · There are a few ways to list tables in MySQL. You can run the command SHOW TABLES once you have logged on to a database to see all tables.

Dec 9, 2025 · How to Get List of All Tables in a SQL Server Database Using TSQL: Best Methods Whether you’re documenting a database, migrating data, auditing schema changes, or simply …

Learn how to display all tables in a SQL Server database using SQL queries. This guide covers different methods, including system views and commands, to retrieve a complete list of tables.

Jul 23, 2025 · Whether you are the database administrator, a developer or an analyst being able to list the tables within the database is a crucial skill. In this article, we will develop the various methods to …

Apr 26, 2024 · Using information_schema.tables, you can query information about the tables in a database to help you understand the schema and structure of the database. We can use …

This could be done for testing purposes, to identify any existing tables before adding or removing any, or for any other reason. This tutorial will discuss how we can list down all the table in MySQL, SQL …

Nov 1, 2024 · In this guide, we’ll cover the most common ways to retrieve a list of tables in SQL with straightforward examples. 1. Using INFORMATION_SCHEMA.TABLES. Most SQL databases, like …

May 6, 2025 · In database management, understanding how to list all the tables within a database is a fundamental skill. Whether you are a database administrator, developer, or data analyst, knowing …