Register now or log in to join your professional community.
You mean you just need to copy table with structure right:
if so create a table <newtable> as select * from oldtable and express the condition which does not meet.
ex.Create TABLE <NEWTAB>
AS (select * from OLDTAB where2<3)
Note:Use * for all Column
simple as this:
Select * Into newTable From oldTable Where1 =2;
Select * Into<New Table> from <OldTable> where1=2;.