Visualisar script de criação de uma tabela

[Regis AraujoParticipante]

Fala Amigo.. boa tarde..

Acho que isto pode te ajudar…

select col.*, com.Comments
from sys.all_tab_columns col,
sys.all_col_comments com
where col.owner = 'OWNER'
and col.table_name = 'NOME_TABELA'
and com.Owner (+) = 'OWNER'
and com.Table_Name (+) = 'NOME_TABELA'
and com.Column_Name (+) = col.Column_Name
order by col.column_id;

select tablespace_name, to_char(pct_free) pct_free, to_char(pct_used) pct_used,
to_char(ini_trans) ini_trans, to_char(max_trans) max_trans,
to_char(initial_extent) initial_extent, to_char(next_extent) next_extent,
to_char(pct_increase) pct_increase,
to_char(min_extents) min_extents, to_char(max_extents) max_extents,
cluster_name
from sys.all_tables
where owner = 'OWNER'
and table_name = 'NOME_TABELA';

Abraços…