create key or index on view

[lucyc]

Is it possible to create a key or index on view??? If it is then how and what is the syntax. Thanks.

 

[pgtek]

hi

here's the syntax

CREATE [ UNIQUE ] [ CLUSTERED | NONCLUSTERED ] INDEX index_name
ON { table | view } ( column [ ASC | DESC ] [ ,...n ] )
[ WITH < index_option > [ ,...n] ]
[ ON filegroup ]

< index_option > :: =
{ PAD_INDEX |
FILLFACTOR = fillfactor |
IGNORE_DUP_KEY |
DROP_EXISTING |
STATISTICS_NORECOMPUTE |
SORT_IN_TEMPDB
}

cheers

pgtek

 

[JayKusch]

Here is a link to get you started!

http://www.databasejournal.com/features/mssql/article.php/2119721

Thanks

J. Kusch

 

[lucyc]

hi pgtek,

Can you send me an example? Is it work on sql 7.0?

 

[lucyc]

Hi Jay,

The schemblinding does't work on SQL7.0

 

[pgtek]

hi check this link

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_create_64l4.asp

cheers

pgtek

 

[JamesLean]

SQL 7 does not support indexed views at all. You need SQL 2000 to do this.

--James