|Main » 2012 » September » 3 » Create Table from existing table
Create Table from existing table
Select * INTO tbem1 from tbemp where 1=2
Because none of the record could satisfy this condition i.e. 1=2. So no data would be copied into newly created table.
Select * INTO tbemp2 from tbemp
Select * INTO tbemp3 from tbemp where depcod=102
Here depcod denotes to department code.
Category: Database |
Views: 1512 |
Added by: Admin
| Tags: with, Structure, From, Other, Copy, Data, table, Another, existing, create
| Rating: 0.0/0||