mysql 判断视图是否存在
时间: 2023-10-11 16:07:02 浏览: 72
在MySQL中,可以通过查询系统视图sys.views来判断某个视图是否存在。可以使用以下SQL语句:
IF NOT EXISTS(SELECT 1 FROM sys.views WHERE name='视图名称')。
这条语句会在sys.views视图中查找是否存在名称为'视图名称'的视图,如果不存在则返回True,存在则返回False。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *3* [MySQL的视图](https://blog.csdn.net/JAX_fire/article/details/125367313)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"]
- *2* [SQL SERVER先判断视图是否存在然后再创建视图的语句](https://blog.csdn.net/weixin_39880328/article/details/113604911)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]