create view pgenius_2..BND_BOOK_VAL_CHNG
as
select SEQ,CTIME,MTIME,ISVALID,GENIUS_UID,INNER_CODE,CHNG_TIME,PRE_BOOK_VAL_CHNG,AFR_BOOK_VAL_CHNG,CHNG_REASON
from
pgenius..BND_BOOK_VAL_CHNG
格式:
create view 表名
as
select 字段名
from
源表库名 ..表名
create view pgenius_2..BND_BOOK_VAL_CHNG
as
select SEQ,CTIME,MTIME,ISVALID,GENIUS_UID,INNER_CODE,CHNG_TIME,PRE_BOOK_VAL_CHNG,AFR_BOOK_VAL_CHNG,CHNG_REASON
from
pgenius..BND_BOOK_VAL_CHNG
格式:
create view 表名
as
select 字段名
from
源表库名 ..表名