达梦查看DDL语句

达梦查看ddl语句
--查看索引

select * from dba_indexes where table_name='SO_SALEINVOICE_B'
select * from dba_ind_columns where table_name='SO_SALEINVOICE_B';

--查看对象ID

select object_id from dba_objects where object_name='SO_SALEINVOICE_B';

select object_id from dba_objects a where object_name='I_SO_32_B_DATE' and owner='BIPZS01';

--查看表定义ddl

select owner,table_name,column_name,data_type,last_analyzed from dba_tab_columns a where table_name='SO_SALEINVOICE_B' and owner='BIPZS01';

call sp_tabledef('BIPZS01','SO_SALEINVOICE_B');

--查看索引定义ddl

select indexdef(33870784,1);