Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Is it possible to set a primary key to a view?

Tags:

sql

sql-server

tsql

materialized-views

Is it possible to set a primary key to a view in SQLServer 2008?

like image 849
Andre Nascentes Avatar asked Jun 17 '10 14:06

Andre Nascentes

1 Answers

You can create a clustered index on a SQL Server view - it's called an indexed view.

See Improving Performance with SQL Server 2008 Indexed Views for details.

like image 131
marc_s Avatar answered Nov 05 '22 11:11

marc_s
Sign in to Comment

Related questions

What structure to use in database for virtual file system?
30 million records. Divy them up into 24 hourly-periods. Sum them for one month. Rinse and Repeat
Table-level diff and sync procedure for T-SQL
Is it possible to create a new T-SQL Operator using CLR Code in SQL Server?
How to select a limited amount of rows for each foreign key?
.NET: Allow NULLS in DB fields?
Query results taking too long on 200K database, speed up tips?
Bulk Insert multiple records and get identity for all using ADO.NET
How to use SQL - INSERT...ON DUPLICATE KEY UPDATE?
how to query with child relations to same table and order this correctly
SQL query: SUM values up to the current record
Calculate differences between rows while grouping with SQL
How to define ENUM in SQL Server 2005? [duplicate]
sql generate unique table/view name
Killing the mysqld process
Check if table exists in c#
Will hibernate java programs have no sql code?
SQL Count unique objects defined by parameters
Using Hibernate's Criteria and Projections to Select Multiple Distinct Columns
Best pattern for storing (product) attributes in SQL Server

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!