Collections:
Show All Tables in a Database in MySQL
How To Get a List of All Tables in a Database in MySQL?
✍: FYIcenter.com
If you want to see the table you have just created, you can use the "SHOW TABLES" command to get a list of all tables in database. The tutorial script gives you a good example:
mysql> SHOW TABLES; +---------------+ | Tables_in_fyi | +---------------+ | links | | tip | +---------------+ 3 rows in set (0.00 sec)
⇒ Show All Columns of an Existing Table in MySQL
⇐ CREATE Command Denied Error in MySQL
2018-03-10, 1474🔥, 0💬
Popular Posts:
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...