Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bmahony993
Yak Posting Veteran
58 Posts |
 Posted - 2008-04-02 : 12:22:14
|
| I have created a SQL view of several tables, and need to add either a primary key or a constraint to this view. I need it for some full text indexing that will be performed on the view. How do I do it?Thanks in advance :) |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-04-02 : 12:27:37
|
| Constraints or Primary keys should be placed on underlying tables and not on view.What is your requirement?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-02 : 12:29:08
|
| Just as you add it to a table. A view is just like a virtual table. |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
bmahony993
Yak Posting Veteran
58 Posts |
Posted - 2008-04-02 : 13:44:11
|
| The view that I am creating is used in a PHP page, and the data needs to be searchable. So, when defining the full text index on the view, I get an error saying there a unique column must be defined on this table/view. |
|
|
|
|
|
|
Adding a constraint to a view