SHOW TABLES

1 Bash × MySQL[ | ]

Bash

Copy

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

Bash

Copy

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

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

sql

Copy

SHOW TABLES;

sql

Copy

SELECT TABLE_NAME FROM TABS WHERE TABLESPACE_NAME='tablespace1';

sql

Copy

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

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

sql

Copy

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

sql

Copy

.tables

sql

Copy

SELECT name FROM sqlite_master WHERE type = "table"

sql

Copy

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