SHOW TABLES

1 Bash × MySQL

mysql -uroot -pP@ssw0rd db1 -e "SHOW TABLES"

mysql -uroot -pP@ssw0rd db1 -e "SHOW TABLES" | tail -n+2

2 MySQL

MySQL SHOW TABLES 문서를 참고하십시오.

SHOW TABLES;

3 Oracle

SELECT TABLE_NAME FROM TABS WHERE TABLESPACE_NAME='tablespace1';

SELECT * FROM USER_OBJECTS WHERE OBJECT_TYPE='TABLE';
SELECT * FROM USER_TABLES;
SELECT * FROM TABS;

4 PostgreSQL

PostgreSQL SHOW TABLES 문서를 참고하십시오.

SELECT table_name FROM information_schema.tables WHERE table_schema = 'public'

5 SQLite

.tables

SELECT name FROM sqlite_master WHERE type = "table"

SELECT * FROM dbname.sqlite_master WHERE type='table';

6 같이 보기

• SHOW TABLE STATUS
• SHOW DATABASES
• SHOW COLUMNS
• TABLE EXISTS
• DESC
• DROP TABLE
• information schema.TABLES
• MySQL 테이블 있는지 확인