34,874
社区成员
发帖
与我相关
我的任务
分享我想增加一个自增量
我建立了个视图，但是我想在视图里再增加一个自增量，我用
alter view view_name add (a int identity(1,1))
却不行，请问？？？？？？
alter view view_name add (a int identity(1,1))
却不行，请问？？？？？？
...全文
请发表友善的回复…
发表回复
welyngj 2003-11-30
- 打赏
- 举报
alter table tbl add id int identity(1,1)
alter view view_name as select id,column1,column2 from tbl
alter view view_name as select id,column1,column2 from tbl
welyngj 2003-11-30
- 打赏
- 举报
ALTER VIEW [ < database_name > .] [ < owner > .] view_name [ ( column [ ,...n ] ) ]
[ WITH < view_attribute > [ ,...n ] ]
AS
select_statement
[ WITH CHECK OPTION ]
< view_attribute > ::=
{ ENCRYPTION | SCHEMABINDING | VIEW_METADATA }
参数
[ WITH < view_attribute > [ ,...n ] ]
AS
select_statement
[ WITH CHECK OPTION ]
< view_attribute > ::=
{ ENCRYPTION | SCHEMABINDING | VIEW_METADATA }
参数
