这个语句有什么问题呢？

显示全部楼层 · 2008-2-13 12:43:03

ifnot exists(SELECT TABLE_NAME FROM

INFORMATION_SCHEMA.VIEWS

where table_name ='xx'
create view xx

as

select....... from ......
go
查询分析器总是报'在关键字 'view' 附近有语法错误。'

千问 · 2008-2-13 12:43:03

if not exists(SELECT TABLE_NAME FROM
INFORMATION_SCHEMA.VIEWS
where table_name ='xx' )
create view xx
as
select ....... from ......
go
是不是没了）

千问 · 2008-2-13 12:43:03

有括号阿exists后面跟了一对括号
if not exists(SELECT TABLE_NAME FROM
INFORMATION_SCHEMA.VIEWS
where table_name ='xx' )
create view xx
as
select ....... from ......
go

千问 · 2008-2-13 12:43:03

USE Northwind
GO
IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.views
WHERE TABLE_NAME = 'CustomersOne' )
drop view CustomersOne
GO
create view CustomersOne
as
select * from Customers

千问 · 2008-2-13 12:43:03

最初由 tigercat 发布
[B]USE Northwind
GO
IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.views
WHERE TABLE_NAME = 'CustomersOne' )
drop view CustomersOne
GO
create view CustomersOne
as
select * from Customers [/B]
支持