General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Nadya,
You don't need a PK for an updatable view. Just tag all of the compsite key fields as the key in the view designer. Of course, a PK puts less strain on the database engine and reduces the size of the WHERE clause.
- Keith
>>>Hi everybody,
>>>
>>>I have a table, which doesn't have a PK. I'd like to make an updatable local view based on this table. Do I need to make a PK? Can I use composite key, like bintoc(DsID)+extryear+extrweek (which should be unique...)?
>>
>>How about giving the table a PK?
>
>Yes, I'm thinking, this might be necessary, and also the simplest solution. On the other hand, I now would need to add NextID table, SP, etc. I was hoping, may be there is workaround... Anyway, I just accidentally zaped this table, so adding PK would not be a big problem... :)
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only