SQL查询 数据库表名：使用 SQL 语句查询数据库表名的方法，sql语句 查询表数据库名

🔍 SQL查询表名关键词 🔍

1. MySQL 🐬

   

   • SHOW TABLES;
   • SELECT table_name FROM information_schema.tables WHERE table_schema = '数据库名';

2. SQL Server 💼

   • SELECT name FROM sys.tables;
   • SELECT table_name FROM information_schema.tables WHERE table_catalog = '数据库名';

3. Oracle 🏛️

   

   • SELECT table_name FROM user_tables;
   • SELECT table_name FROM all_tables WHERE owner = '用户名';

4. PostgreSQL 🐘

   • \dt (命令行)
   • SELECT table_name FROM information_schema.tables WHERE table_schema = 'public';

5. SQLite 📱

   

   • .tables (命令行)
   • SELECT name FROM sqlite_master WHERE type = 'table';

✨ 提示：替换引号内名称为实际值，注意权限限制哦！