How to load all columns while residint load

[#1]

Hi friends

I have a table. I want all the coumns expect two in to new table. Is there any way to get all the coumns into next table without typing all the column names again.

Thanks

Pavan

[PrashantSangle]

Hi,

Use

Load *

Resident oldTableName;

Regards

[MarcoWedel · Accepted solution]

newTableName:

Load *

Resident oldTableName;

Drop Fields unwantedField1, unwantedField2 From newTableName;