SQLServer
SELECT
c.column_id,
c.name,
p.value,
c.max_length,
c.is_nullable,
c.is_identity,
p.*
FROM sys.extended_properties p ,
sys.columns c
WHERE p.major_id = OBJECT_ID('table_name')
and p.major_id = c.object_id
and p.minor_id = c.column_id;
oracle
set line 200 pages 50000 wrap on long 999999 serveroutput on;
EXECUTE DBMS_METADATA.SET_TRANSFORM_PARAM(
DBMS_METADATA.SESSION_TRANSFORM,'STORAGE',false
);
select dbms_metadata.get_ddl('TABLE', 'table_name'')
from dual;