Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 12 Feb 2008 @ 16:22:17 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Writing to tables thru views
From:   william.gregg

Two items:

1) It is my understanding that restrictions on table updates thru views block views built from joins, derived data, or column functions (e.g. SUM, COUNT, CSUM) from performing the ins/upd/del action.

Has anyone found a way around this?

2) Adding the WITH CHECK OPTION enforces constraints thru the WHERE clause (otherwise the WHERE clause is ignored.)

I recall that the WITH CHECK OPTION clause was not working correctly. Is this true?

Will employment of the WITH CHECK OPTION produce faulty updates?


Bill Gregg

Teradata Team
Thomson Healthcare

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023