如何解决SQL视图错误 [英] How to solve SQL view error

问题描述

地狱全部，

如果这个View（VW_ME）存在，我想检查我的数据库，结果是真的它应该因为对它进行一些修改而被droped，否则它应该创建它。

贝娄是我的SQL语句

Hell ALL,
I want to check my database if this View (VW_ME) exists, it result is true it should be droped because of some modification on it, other wise it should create it.
bellow is my SQL STATEMENT

IF exists(select 1 from [dbo].[vw_Me])
	BEGIN
	   drop view [dbo].[vw_ME]
	END
ELSE 
	BEGIN
	declare @sql varchar(1000)
	select @sql = 'CREATE VIEW VW_ME AS
		   SELECT * FROM drug'
	 exec (@sql)
	END

sql server management studio（SSMS）返回错误以下



Msg 208，Level 16，State 1，Line 1

无效的对象名称'dbo.vw_Me'。



任何帮助将不胜感激。



谢谢大家的不断支持。



删除了SHOUTING，添加了代码块 - OriginalGriff [/ edit]

sql server management studio (SSMS) return the error bellow

Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.vw_Me'.

Any help will be appreciated.

thank you all for your constant support.

[edit]SHOUTING removed, Code block added - OriginalGriff[/edit]

推荐答案

我建​​议检查视图是否存在，而不是尝试从中进行选择。当它不存在时，你会得到你得到的错误。所以，这样做。

I suggest checking if the view exists, rather than trying to select from it. When it does not exist you'll get the error you are getting. So, do it this way.

IF OBJECT_ID('vw_Me', 'V') IS NOT NULL
    DROP VIEW vw_Me;
GO
... -- now create it

这篇关于如何解决SQL视图错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！