How can I keep only a specific set of columns and remove all others?

3 vues

Réponse

You can use the `keep` parameter, providing a list of the column names that you wish to retain in the table. All other columns will be dropped.
Did this answer help you?
alterTable

table

See technical action
Other questions about alterTable
What is the difference between the top-level `drop` parameter and the `drop` option within the `columns` parameter? What does the `lifetime` parameter control? What is the purpose of the `tableRedistUpPolicy` parameter? How can I rename a table using this action? Can I reorder the columns in my table?
Copyright © WeAreCAS 2023-2025