sqlserver查看表结构

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;