对视图修改删除增加属性的sql语句是什么
2个回答
展开全部
对视图修改就是重建，跟存储过程之类的差不多
alter view view_name
as
语体
alter view view_name
as
语体
更多追问追答
追问
……那我可以只增加我想要的 可以不把原来有的都加上吗
追答
不可以，重建嘛，就跟存储过程一样，你说你想在存储过程中多加一个结果集输出，你能就只alter一个select吗，不是要把整个原有的都写上嘛
本回答由提问者推荐
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
展开全部
语法
ALTER VIEW [ < database_name > .] [ < owner > .] view_name [ ( column [ ,...n ] ) ]
[ WITH < view_attribute > [ ,...n ] ]
AS
select_statement
[ WITH CHECK OPTION ]
示例
ALTER VIEW yourview
AS
SELECT title, mycount = @@ ROWCOUNT, ytd_sales
FROM titles
WHERE type = 'mod_cook'
ALTER VIEW [ < database_name > .] [ < owner > .] view_name [ ( column [ ,...n ] ) ]
[ WITH < view_attribute > [ ,...n ] ]
AS
select_statement
[ WITH CHECK OPTION ]
示例
ALTER VIEW yourview
AS
SELECT title, mycount = @@ ROWCOUNT, ytd_sales
FROM titles
WHERE type = 'mod_cook'
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
