Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Feature: Alter table unset options #16436

Open
dantengsky opened this issue Sep 11, 2024 · 1 comment
Open

Feature: Alter table unset options #16436

dantengsky opened this issue Sep 11, 2024 · 1 comment
Labels
C-feature Category: feature

Comments

@dantengsky
Copy link
Member

Summary

e.g.

ALTER TABLE t UNSET OPTIONS (data_retention_period_in_hours);

which removes the option from table t, if applicable (not all the table options are allowed to be removed)

@dantengsky dantengsky added the C-feature Category: feature label Sep 11, 2024
Copy link

dosubot bot commented Sep 11, 2024

To implement the feature to alter a table and unset options, such as removing the data_retention_period_in_hours option from a table, you can use the following SQL statement:

ALTER TABLE t UNSET OPTIONS(data_retention_period_in_hours);

This statement will remove the data_retention_period_in_hours option from the table t [1].

To continue talking to Dosu, mention @dosu.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
C-feature Category: feature
Projects
None yet
Development

No branches or pull requests

1 participant