达梦查看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);

--查看索引有哪些列组成

select * from  SYS.DBA_IND_COLUMNS  a where a.TABLE_NAME='BD_MATERIAL' and a.table_OWNER='BIPZS01'