information_schema中的所有表和视图
来源:互联网 发布:matlab 遍历矩阵 编辑:程序博客网 时间:2024/05/20 05:27
select table_name from information_schema.tables where table_schema = ‘information_schema’;
“attributes”
“character_sets”
“check_constraint_routine_usage”
“information_schema_catalog_name”
“applicable_roles”
“administrable_role_authorizations”
“check_constraints”
“collations”
“collation_character_set_applicability”
“column_domain_usage”
“column_privileges”
“column_udt_usage”
“columns”
“constraint_column_usage”
“constraint_table_usage”
“domain_constraints”
“domain_udt_usage”
“domains”
“enabled_roles”
“key_column_usage”
“parameters”
“referential_constraints”
“role_column_grants”
“routine_privileges”
“role_routine_grants”
“routines”
“schemata”
“sequences”
“sql_features”
“sql_implementation_info”
“sql_languages”
“sql_packages”
“sql_parts”
“sql_sizing”
“sql_sizing_profiles”
“table_constraints”
“table_privileges”
“role_table_grants”
“tables”
“transforms”
“triggered_update_columns”
“triggers”
“udt_privileges”
“role_udt_grants”
“usage_privileges”
“role_usage_grants”
“user_defined_types”
“view_column_usage”
“view_routine_usage”
“view_table_usage”
“views”
“data_type_privileges”
“element_types”
“_pg_foreign_table_columns”
“column_options”
“_pg_foreign_data_wrappers”
“foreign_data_wrapper_options”
“foreign_data_wrappers”
“_pg_foreign_servers”
“foreign_server_options”
“foreign_servers”
“_pg_foreign_tables”
“foreign_table_options”
“foreign_tables”
“_pg_user_mappings”
“user_mapping_options”
“user_mappings”
参考:http://www.postgresql.org/docs/9.1/static/information-schema.html
- information_schema中的所有表和视图
- 关于mysql中的information_schema.tables和information_schema.columns详解
- 获取当前数据库中的所有表和视图
- select * from information_schema.tables 查询所有表
- 信息架构视图 INFORMATION_SCHEMA
- mysql information_schema 视图信息
- mysql中的information_schema数据库表说明:
- mysql 中的information_schema是什么
- 关于MySQL中的information_schema
- 如何查询数据库中的所有触发器、储存过程、视图、表
- SQL 利用INFORMATION_SCHEMA系统视图如何一步一步获取表的主外键信息
- Mysql 5.7 information_schema 的status和variables表deprecated
- sql server2005删除所有用户视图和删除表
- SqlServer 查询包含A字段的所有 表和视图
- sqlserver 删除所有表和视图对象sql
- sql 获取数据库中所有表和视图的列
- MySQL中的information_schema数据库详解
- 关于PostgreSQL数据库中的information_schema
- PostgreSQL系统表和视图
- POJ 3264 Balanced Lineup (RMQ)
- 记安装三系统失败
- IOS Apps 开发(Swift)(5)——Work with View Controllers
- SQL语句插入数据库2种方式
- information_schema中的所有表和视图
- 数据存储
- java基础——各种变量你晕了不?
- install mariedb
- java unicode c++ socket
- RTSP协议、RTMP协议、HTTP协议的区别
- 大型网站架构系列:电商网站架构案例(3)
- 解决The SDK platform-tools version ((23)) is too old to check APIs compiled with API 23
- <javascript>每日小结