Thread: Copy table without data

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

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

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

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

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

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.

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

Originally Posted by 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

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

Originally Posted by 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

you can use "paste special" option