Hi,
Is there a way to get the DDL of table without having constraints(primary,check)? I tried below
create table T1
as select * from T2 where 1 = 0;
but the above one is coming with constraints, is there a way to get without them as i need to create exact copy of T2 without data and have its column structure including partitions , Only constraints are not required