问题描述
我在 SQL Server 数据库中创建了一个视图,它只是两个表的连接.
I have created a view in a SQL Server database which is just a join of two tables.
有什么办法可以在这个视图的行中插入一个唯一的主键……或者我不确定如何将其中一个列名指定为主键……有什么想法吗?
Is there any way I can insert a unique primary key into the rows of this view ...or I'm not sure how I can specify one of the column names to be a primary key...any ideas?
谢谢
推荐答案
您必须创建物化(索引)视图才能添加唯一索引.但是你不能创建PK约束.
You would have to create materialized (indexed) view in order to be able to add unique index. But you can't create PK constraint.
CREATE VIEW v_test WITH SCHEMABINDING --optional AS SELECT id from table GO CREATE UNIQUE CLUSTERED INDEX idx_id ON v_test (id) GO