Tables

[holdingbe]

hi,
how to create table from other table with index and constraints..

for example,

create table temp
as
select *
from employees;

the scripts created only table with not null constraints. I want to extract all constraints including index from base tables

Regards
michael

[debasisdas]

When a table is created by copying the existing table, the constraints and the indexes are not copied.