Generate a new table from an existing table

Is there any way to generate a new table according to the data of an existing table. For example, a new table with only some columns of the existing table.

if you are using scripting, yes. Out of the box, no.

Thanks for your reply. Would you please show me the api to read data from a specific table?