什么是网络营销最基本最重要的工具_seo和sem的区别_互联网营销师培训教材_世界羽联巡回赛总决赛

1.查询表名清单

SELECT *
FROM information_schema.tables
WHERE table_type = 'BASE TABLE'

2.查询视图名清单

SELECT *
FROM information_schema.TABLES
WHERE table_type ='VIEW' 
ORDER BY TABLE_NAME

3.查询存储过程名清单

SELECT *
FROM   INFORMATION_SCHEMA.ROUTINES
WHERE  ROUTINE_TYPE = 'PROCEDURE'
ORDER BY SPECIFIC_NAME