–查询表的索引
SELECT ‘CREATE INDEX ’ || INDEX_NAME || ’ ON ’ || TABLE_NAME ||
’ (’ || LISTAGG(COLUMN_NAME, ', ') WITHIN GROUP (ORDER BY COLUMN_POSITION) || ‘)’ AS index_sql
FROM DBA_IND_COLUMNS
WHERE TABLE_NAME = ‘BAS_ACCOUNT_CLS’ AND
GROUP BY INDEX_NAME, TABLE_NAME;

–查询表的约束
SELECT ‘ALTER TABLE ’ || d.TABLE_NAME || ’ ADD CONSTRAINT ’ || d.CONSTRAINT_NAME ||
CASE c.CONSTRAINT_TYPE
WHEN ‘P’ THEN ’ PRIMARY KEY (’
WHEN ‘U’ THEN ’ UNIQUE (’
WHEN ‘R’ THEN ’ FOREIGN KEY (’
END ||
LISTAGG(d.COLUMN_NAME, ', ') WITHIN GROUP (ORDER BY POSITION) || ‘)’ AS constraint_sql
FROM DBA_CONS_COLUMNS d,dba_constraints c
WHERE d.owner=c.owner and d.table_name=c.table_name and
d.TABLE_NAME = ‘BAS_AGENCY_EXTEND’
GROUP BY d.CONSTRAINT_NAME, d.TABLE_NAME, c.CONSTRAINT_TYPE;

–查询表的触发器
select TABLE_OWNER,TABLE_NAME,TRIGGER_NAME,TRIGGER_BODY
from USER_TRIGGERS where TABLE_OWNER=‘IFMIS_14_25’ AND BASE_OBJECT_TYPE=‘TABLE’