Copy table without data

[rahul.kgupta79]

suppose there are two seperate accounts one account has a table, how can that table be copied without the data being copied into another account

[priyasp_msit]

create table table_name as select * from table_name where 1=2;

[ushalakshmi]

select * into [New tab-name] from [old tab-name]

hope this will helpfull.............

[ashalalaxmi2002]

CREATE TABLE table_name2 as select * from table_name1 where 1=0

[debasisdas]

it is not necessary to give as 1=0 or 1=2 .

In the where clause you can provide any condition which evalutes to false.

[majidms7]

we can give negative value also, for this we should have known what records that table contains.

[ec0321]

suppose there are two seperate accounts one account has a table, how can that table be copied without the data being copied into another account

Need not worry to much for such issues .have pepsi and enjoy life

[krishna1986]

suppose there are two seperate accounts one account has a table, how can that table be copied without the data being copied into another account

you can use "paste special" option