更新时间:2023-01-19 23:30:30
- 检索有关数据库中包含的索引的信息。
SELECT * FROM
INFORMATION_SCHEMA.INDEXES
-- Retrieves information about the indexes contained in the database. SELECT * FROM INFORMATION_SCHEMA.INDEXES
- 检索数据库中的所有表,包括系统表。
SELECT * FROM
INFORMATION_SCHEMA.TABLES
-- Retrieves all the Tables in the database including the System tables. SELECT * FROM INFORMATION_SCHEMA.TABLES