select dbms_metadata.get_ddl(‘TABLE’,‘表名’,‘用户名’) from dual;

show create table YOUR_TABLE_NAME

-- 表定义
select TABLEDEF(USER, 'YOUR_TABLE_NAME');

-- 表注释
select null as COLNAME, COMMENT$ from SYSTABLECOMMENTS where TABLE_TYPE='TABLE' and SCHNAME=USER and TVNAME='YOUR_TABLE_NAME';

-- 列注释
select COLNAME, COMMENT$ from SYSCOLUMNCOMMENTS where TABLE_TYPE='TABLE' and SCHNAME=USER and TVNAME='YOUR_TABLE_NAME';

-- 索引定义
SELECT indexdef(id, 1)
FROM sysobjects
WHERE pid = (SELECT id
             FROM sys.sysobjects
             WHERE NAME = 'YOUR_TABLE_NAME'
                   AND "SUBTYPE$" = 'UTAB'
                   AND schid = sf_get_schema_id_by_name(USER))
      AND subtype$ = 'INDEX'
      AND NAME != 'INDEX' || id;