Successfully created the view, but an error occurs immediately when trying to open and modify it!

This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: 创建视图成功,但是打开直接修改就直接报错!

| username: Running

The image is not available for translation. Please provide the text content directly.

| username: CuteRay | Original post link

TiDB does not currently support ALTER VIEW.

| username: tidb菜鸟一只 | Original post link

What to modify? Just delete and recreate it.

| username: Running | Original post link

I didn’t see it mentioned on the official website.

| username: Running | Original post link

Your approach is too aggressive; it doesn’t address the root problem.

| username: 啦啦啦啦啦 | Original post link

The official website mentions, in the link above, that currently views in TiDB do not support ALTER VIEW, but you can use CREATE OR REPLACE as a substitute.

| username: Running | Original post link

Found it, thank you everyone.

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.