ALL_CONS_COLUMNS - OceanBase 数据库 V4.2.1 | OceanBase 文档中心

文档反馈

分布式版-V4.2.1LTS

V4.2.1 文档更新记录
简介
快速上手
应用开发
部署数据库
数据迁移
管理数据库
参考指南
- 系统原理
- 系统管理
- 数据库对象管理
- 数据库设计规范和约束
- SQL 参考
- 系统视图
  - 系统视图概述
  - 系统视图总览
  - V3.x 与 V4.x 视图变更
  - SYS 租户系统视图
  - MySQL 租户系统视图
  - Oracle 租户系统视图
    - 字典视图
      - ALL_ALL_TABLES
      - ALL_ARGUMENTS
      - ALL_COL_COMMENTS
      - ALL_COLL_TYPES
      - ALL_COL_PRIVS
      - ALL_CONSTRAINTS
      - ALL_CONS_COLUMNS
      - ALL_DEF_AUDIT_OPTS
      - ALL_ERRORS
      - ALL_INDEXES
      - ALL_IND_COLUMNS
      - ALL_IND_EXPRESSIONS
      - ALL_IND_PARTITIONS
      - ALL_IND_SUBPARTITIONS
      - ALL_METHOD_PARAMS
      - ALL_OBJECTS
      - ALL_PART_INDEXES
      - ALL_PART_KEY_COLUMNS
      - ALL_PART_TABLES
      - ALL_PROCEDURES
      - ALL_PROFILES
      - ALL_SCHEDULER_JOB_ARGS
      - ALL_SCHEDULER_PROGRAM_ARGS
      - ALL_SEQUENCES
      - ALL_SOURCE
      - ALL_SUBPARTITION_TEMPLATES
      - ALL_SUBPART_KEY_COLUMNS
      - ALL_SYNONYMS
      - ALL_TABLES
      - ALL_TAB_COLS
      - ALL_TAB_COLUMNS
      - ALL_TAB_COMMENTS
      - ALL_TAB_PARTITIONS
      - ALL_TAB_PRIVS
      - ALL_TAB_STATS_HISTORY
      - ALL_TAB_SUBPARTITIONS
      - ALL_TRIGGERS
      - ALL_TYPES
      - ALL_TYPE_ATTRS
      - ALL_TYPE_METHODS
      - ALL_USERS
      - ALL_VIEWS
      - ALL_DIRECTORIES
      - ALL_DEPENDENCIES
      - ALL_PART_COL_STATISTICS
      - ALL_PART_HISTOGRAMS
      - ALL_SUBPART_COL_STATISTICS
      - ALL_SUBPART_HISTOGRAMS
      - ALL_TAB_COL_STATISTICS
      - ALL_TAB_HISTOGRAMS
      - ALL_TAB_STATISTICS
      - AUDIT_ACTIONS
      - DBA_ALL_TABLES
      - DBA_ARGUMENTS
      - DBA_AUDIT_EXISTS
      - DBA_AUDIT_OBJECT
      - DBA_AUDIT_SESSION
      - DBA_AUDIT_STATEMENT
      - DBA_AUDIT_TRAIL
      - DBA_COLL_TYPES
      - DBA_COL_COMMENTS
      - DBA_COL_PRIVS
      - DBA_CONSTRAINTS
      - DBA_CONS_COLUMNS
      - DBA_CONTEXT
      - DBA_ERRORS
      - DBA_INDEXES
      - DBA_IND_COLUMNS
      - DBA_IND_EXPRESSIONS
      - DBA_IND_PARTITIONS
      - DBA_IND_SUBPARTITIONS
      - DBA_OB_DATABASES
      - DBA_OB_LS_LOCATIONS
      - DBA_OB_MAJOR_COMPACTION
      - DBA_OB_SERVICES
      - DBA_OB_TABLEGROUP_TABLES
      - DBA_OB_TABLEGROUP_SUBPARTITIONS
      - DBA_OB_TABLEGROUP_PARTITIONS
      - DBA_OB_TABLEGROUPS
      - DBA_OB_TABLET_REPLICAS
      - DBA_OB_TABLET_TO_LS
      - DBA_OB_ZONE_MAJOR_COMPACTION
      - DBA_METHOD_PARAMS
      - DBA_OBJECTS
      - DBA_OBJ_AUDIT_OPTS
      - DBA_PART_INDEXES
      - DBA_PART_KEY_COLUMNS
      - DBA_PART_TABLES
      - DBA_PROCEDURES
      - DBA_PROFILES
      - DBA_ROLES
      - DBA_ROLE_PRIVS
      - DBA_SCHEDULER_JOB_ARGS
      - DBA_SCHEDULER_JOBS
      - DBA_SCHEDULER_PROGRAM
      - DBA_SCHEDULER_PROGRAM_ARGS
      - DBA_SEGMENTS
      - DBA_SOURCE
      - DBA_STMT_AUDIT_OPTS
      - DBA_SUBPARTITION_TEMPLATES
      - DBA_SUBPART_KEY_COLUMNS
      - DBA_SYNONYMS
      - DBA_SYS_PRIVS
      - DBA_TABLES
      - DBA_TABLESPACES
      - DBA_TAB_COLS
      - DBA_TAB_COLUMNS
      - DBA_TAB_COMMENTS
      - DBA_TAB_PARTITIONS
      - DBA_TAB_PRIVS
      - DBA_TAB_STATS_HISTORY
      - DBA_TAB_SUBPARTITIONS
      - DBA_TRIGGERS
      - DBA_TYPES
      - DBA_TYPE_ATTRS
      - DBA_TYPE_METHODS
      - DBA_USERS
      - DBA_VIEWS
      - DBA_RECYCLEBIN
      - DBA_DEPENDENCIES
      - DBA_RSRC_CONSUMER_GROUPS
      - DBA_RSRC_GROUP_MAPPINGS
      - DBA_RSRC_PLANS
      - DBA_RSRC_PLAN_DIRECTIVES
      - DBA_DIRECTORIES
      - DBA_JOBS
      - DBA_JOBS_RUNNING
      - DBA_PART_COL_STATISTICS
      - DBA_PART_HISTOGRAMS
      - DBA_SUBPART_COL_STATISTICS
      - DBA_SUBPART_HISTOGRAMS
      - DBA_TAB_COL_STATISTICS
      - DBA_TAB_HISTOGRAMS
      - DBA_TAB_STATISTICS
      - NLS_DATABASE_PARAMETERS
      - NLS_INSTANCE_PARAMETERS
      - NLS_SESSION_PARAMETERS
      - STMT_AUDIT_OPTION_MAP
      - TENANT_VIRTUAL_GLOBAL_VARIABLE
      - TENANT_VIRTUAL_SESSION_VARIABLE
      - USER_ALL_TABLES
      - USER_ARGUMENTS
      - USER_AUDIT_OBJECT
      - USER_AUDIT_SESSION
      - USER_AUDIT_STATEMENT
      - USER_AUDIT_TRAIL
      - USER_COLL_TYPES
      - USER_COL_COMMENTS
      - USER_COL_PRIVS
      - USER_CONSTRAINTS
      - USER_CONS_COLUMNS
      - USER_ERRORS
      - USER_INDEXES
      - USER_IND_COLUMNS
      - USER_IND_EXPRESSIONS
      - USER_IND_PARTITIONS
      - USER_IND_SUBPARTITIONS
      - USER_OBJECTS
      - USER_PART_INDEXES
      - USER_PART_KEY_COLUMNS
      - USER_PART_TABLES
      - USER_PROCEDURES
      - USER_PROFILES
      - USER_ROLE_PRIVS
      - USER_SEGMENTS
      - USER_SEQUENCES
      - USER_SOURCE
      - USER_SUBPARTITION_TEMPLATES
      - USER_SUBPART_KEY_COLUMNS
      - USER_SYNONYMS
      - USER_SYS_PRIVS
      - USER_TAB_STATS_HISTORY
      - USER_TAB_SUBPARTITIONS
      - USER_TRIGGERS
      - USER_TABLES
      - USER_TABLESPACES
      - USER_TAB_COLS
      - USER_TAB_COLUMNS
      - USER_TAB_COMMENTS
      - USER_TAB_PARTITIONS
      - USER_TAB_PRIVS
      - USER_TYPES
      - USER_TYPE_ATTRS
      - USER_TYPE_METHODS
      - USER_VIEWS
      - USER_JOBS
      - USER_RECYCLEBIN
      - USER_DEPENDENCIES
      - USER_PART_COL_STATISTICS
      - USER_PART_HISTOGRAMS
      - USER_SUBPART_COL_STATISTICS
      - USER_SUBPART_HISTOGRAMS
      - USER_TAB_COL_STATISTICS
      - USER_TAB_HISTOGRAMS
      - USER_TAB_STATISTICS
      - ROLE_TAB_PRIVS
      - ROLE_SYS_PRIVS
      - ROLE_ROLE_PRIVS
      - DICTIONARY
      - DICT
      - DBA_OB_BACKUP_SET_FILES
      - DBA_OB_BACKUP_JOBS
      - DBA_OB_BACKUP_JOB_HISTORY
      - DBA_OB_BACKUP_TASKS
      - DBA_OB_BACKUP_TASK_HISTORY
      - DBA_OB_ARCHIVELOG_PIECE_FILES
      - DBA_OB_RESTORE_PROGRESS
      - DBA_OB_RESTORE_HISTORY
      - DBA_OB_ARCHIVELOG
      - DBA_OB_ARCHIVELOG_SUMMARY
      - DBA_OB_BACKUP_PARAMETER
      - DBA_OB_ARCHIVE_DEST
      - DBA_OB_OUTLINE_CONCURRENT_HISTORY
      - DBA_OB_OUTLINES
      - DBA_OB_CONCURRENT_LIMIT_SQL
      - DBA_OB_BACKUP_DELETE_JOBS
      - DBA_OB_BACKUP_DELETE_JOB_HISTORY
      - DBA_OB_BACKUP_DELETE_TASKS
      - DBA_OB_BACKUP_DELETE_TASK_HISTORY
      - DBA_OB_BACKUP_STORAGE_INFO
      - DBA_OB_BACKUP_STORAGE_INFO_HISTORY
      - DBA_OB_BACKUP_DELETE_POLICY
      - DBA_OB_DEADLOCK_EVENT_HISTORY
      - ALL_IND_STATISTICS
      - DBA_IND_STATISTICS
      - USER_IND_STATISTICS
      - ALL_TAB_MODIFICATIONS
      - DBA_TAB_MODIFICATIONS
      - USER_TAB_MODIFICATIONS
      - DBA_SQL_PLAN_BASELINES
      - DBA_SQL_MANAGEMENT_CONFIG
      - USER_SCHEDULER_JOB_ARGS
      - USER_SCHEDULER_PROGRAM_ARGS
      - DBA_OB_LS
      - DBA_OB_TABLE_LOCATIONS
      - DBA_OB_FREEZE_INFO
      - DBA_OB_LS_REPLICA_TASKS
      - DBA_OB_LS_REPLICA_TASK_HISTORY
      - DBA_SEQUENCES
      - DBA_SCHEDULER_WINDOWS
      - ALL_SCHEDULER_WINDOWS
      - DBA_OB_DATABASE_PRIVILEGE
      - DBA_OB_USER_DEFINED_RULES
      - DBA_OB_TENANTS
      - DBA_OB_LS_LOG_ARCHIVE_PROGRESS
      - DBA_POLICIES
      - ALL_POLICIES
      - USER_POLICIES
      - DBA_POLICY_GROUPS
      - ALL_POLICY_GROUPS
      - USER_POLICY_GROUPS
      - DBA_POLICY_CONTEXTS
      - ALL_POLICY_CONTEXTS
      - USER_POLICY_CONTEXTS
      - DBA_SEC_RELEVANT_COLS
      - ALL_SEC_RELEVANT_COLS
      - USER_SEC_RELEVANT_COLS
      - DBA_OB_LS_ARB_REPLICA_TASKS
      - DBA_OB_LS_ARB_REPLICA_TASK_HISTORY
      - ALL_TRIGGER_ORDERING
      - DBA_TRIGGER_ORDERING
      - USER_TRIGGER_ORDERING
      - DBA_OB_RSRC_IO_DIRECTIVES
      - ALL_DB_LINKS
      - DBA_DB_LINKS
      - USER_DB_LINKS
      - DBA_OB_DATA_DICTIONARY_IN_LOG
      - DBA_OB_TASK_OPT_STAT_GATHER_HISTORY
      - DBA_OB_TABLE_OPT_STAT_GATHER_HISTORY
      - DBA_OB_LOG_RESTORE_SOURCE
      - DBA_OB_TABLE_STAT_STALE_INFO
      - DBA_OB_EXTERNAL_TABLE_FILES
      - ALL_OB_EXTERNAL_TABLE_FILES
      - DBA_OB_BALANCE_JOBS
      - DBA_OB_BALANCE_JOB_HISTORY
      - DBA_OB_BALANCE_TASKS
      - DBA_OB_BALANCE_TASK_HISTORY
      - DBA_OB_TRANSFER_TASKS
      - DBA_OB_TRANSFER_TASK_HISTORY
      - DBA_OB_ACCESS_POINT
      - DBA_OB_LS_HISTORY
      - DBA_OB_TENANT_EVENT_HISTORY
      - DBA_SCHEDULER_JOB_RUN_DETAILS
      - DBA_WR_SNAPSHOT
      - DBA_WR_ACTIVE_SESSION_HISTORY
      - DBA_WR_STATNAME
      - DBA_WR_SYSSTAT
      - DBA_WR_CONTROL
      - DBA_OB_RECOVER_TABLE_JOBS
      - DBA_OB_IMPORT_TABLE_JOBS
      - DBA_OB_IMPORT_TABLE_TASKS
      - DBA_OB_RECOVER_TABLE_JOB_HISTORY
      - DBA_OB_IMPORT_TABLE_JOB_HISTORY
      - DBA_OB_IMPORT_TABLE_TASK_HISTORY
      - DBMS_LOCK_ALLOCATED
      - USER_USERS
      - DBA_OB_TRANSFER_PARTITION_TASKS
      - DBA_OB_TRANSFER_PARTITION_TASK_HISTORY
    - 性能视图
  - 常见统计事件说明
  - 常见等待事件说明
- 配置项和系统变量
- 错误码
- 性能调优
- 性能测试
- 数据库代理
- 驱动
- 平台产品
- 组件 & 工具
常见问题
版本发布记录
术语

ALL_CONS_COLUMNS

更新时间：2026-07-15 22:01:31

分享

功能

查看用户可访问的所有表的约束中的列信息。

功能适用性

该视图仅适用于 OceanBase 数据库 Oracle 模式。

相关视图

USER_CONS_COLUMNS
DBA_CONS_COLUMNS

字段说明

字段名称	类型	是否可以为 NULL	描述
OWNER	VARCHAR2(128)	NO	约束的拥有者
CONSTRAINT_NAME	VARCHAR2(128)	NO	约束名字
TABLE_NAME	VARCHAR2(128)	NO	约束所在表的表名
COLUMN_NAME	VARCHAR2(4000)	NO	约束中的列名
POSITION	NUMBER	NO	列在约束中的位置

有帮助

无帮助