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

Translated
1

Note:
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.

2
| username: CuteRay | Original post link

TiDB does not currently support ALTER VIEW.

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

What to modify? Just delete and recreate it.

4
| username: Running | Original post link

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

5
| username: Running | Original post link

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

6
| 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.

7
| username: Running | Original post link

Found it, thank you everyone.

8
| username: system | Original post link

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