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.

[QUOTE=rahul.kgupta79;28293]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[/QUOTE]


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

[QUOTE=rahul.kgupta79;28293]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[/QUOTE]

you can use "paste special" option