krfs.net
当前位置:首页 >> 数据库修改视图语句 >>

数据库修改视图语句

你好!exec sp_rename '旧视图名','新视图名' 如果对你有帮助,望采纳.

1、rename 原试图名 to 现试图名;2、create view 视图名as[with check option]

sql server中修改视图名字的SQL语句如下:1、rename 原试图名 to 现试图名;2、输入下面语句即可完成:CREATE VIEW 视图名 AS<select statement> [WITH CHECK OPTION]

CREATE VIEW 视图名AS[WITH CHECK OPTION]

.create or replace view 语句.//如视图存在则覆盖,如不存在则创建.create or replace view algorith=temptable view student_view(nid,id,name) as select id,pid,title from student;

alter view 视图名 as select 语句 不然你给一个题目?

创建视图:CREATE VIEW [ .] [ .] view_name [ ( column [ ,n ] ) ] [ WITH [ ,n ] ] AS select_statement [ WITH CHECK OPTION ] ::= { ENCRYPTION | SCHEMABINDING | VIEW_METADATA } 修改视图:ALTER VIEW [ .] [ .] view_name [ ( column

对视图修改就是重建,跟存储过程之类的差不多alter view view_nameas语体

不能用T-SQL语句更改视图名的,因为修改视图是 Alter view view_name [with encryption] as select_statement是用视图名做标记,不能改,你要改有两种方法,1:用界面改,2:用语句删了,再建.

创建视图 CREATE [OR REPLACE] VIEW 视图名(列1,列2) AS SELECT (列1,列2) FROM ; [WITH [CASCADED|LOCAL] CHECK OPTION]修改视图 CREATE OR REPLACE VIEW 视图名 AS SELECT [ ] FROM [ ]; [WITH [CASCADED

网站首页 | 网站地图
All rights reserved Powered by www.krfs.net
copyright ©right 2010-2021。
内容来自网络,如有侵犯请联系客服。zhit325@qq.com