关系 "sde_table_registry_ext" 不存在
时间: 2024-03-26 14:38:12 浏览: 99
SDE数据库表关系
4星 · 用户满意度95%
如果 `sde_table_registry_ext` 表不存在,可以通过以下 SQL 语句创建该表:
```
CREATE TABLE sde_table_registry_ext
(
registration_id integer NOT NULL,
table_name character varying(64) NOT NULL,
owner character varying(64) NOT NULL,
description character varying(160) NOT NULL,
column_name character varying(64) NOT NULL,
type character varying(20) NOT NULL,
is_nullable character varying(3) NOT NULL,
default_value character varying(160),
min_value double precision,
max_value double precision,
constraint_name character varying(64),
has_index character varying(3),
is_spatial character varying(3),
alias character varying(160),
model_name character varying(160),
owner_type character varying(8),
creator character varying(64),
created_date timestamp,
last_modifier character varying(64),
last_modified_date timestamp,
is_versioned character varying(3),
version_column character varying(64),
version_column_type character varying(12),
default_version character varying(64),
state_id integer,
state_date timestamp,
state_user character varying(64),
allowed_states character varying(160),
dataset_id character varying(64),
dataset_info character varying(160),
CONSTRAINT sde_table_registry_ext_pkey PRIMARY KEY (registration_id)
);
```
创建完 `sde_table_registry_ext` 表后,可以使用之前提到的 SQL 语句来修改数据别名。
阅读全文