可以1 create view 视图名 WITH SCHEMABINDING --绑定模式 as select A,B from dbo.TB “dbo”表模式2 create UNIQUE CLUSTERED index ix_v_question_vote on v_question_voting(questionid)
1 create view 视图名 WITH SCHEMABINDING --绑定模式 as select A,B from dbo.TB “dbo”表模式2 create UNIQUE CLUSTERED index ix_v_question_vote on v_question_voting(questionid)
我刚试了一下,出现以下提示:
无法在视图 'Invoices' 上创建 索引,因为该视图未绑定到架构。
create view 视图名
WITH SCHEMABINDING --绑定模式
as
select A,B from dbo.TB “dbo”表模式2
create UNIQUE CLUSTERED index ix_v_question_vote on v_question_voting(questionid)
create view 视图名
WITH SCHEMABINDING --绑定模式
as
select A,B from dbo.TB “dbo”表模式2
create UNIQUE CLUSTERED index ix_v_question_vote on v_question_voting(questionid)