Target Table Options Dialog
The Target Table Options dialog enables you to set options that control the behavior of the target table when you update rows. The dialog contains the following elements:
- Before Table Options - Inserts options before the target table or view name. For example, the /*+ FIRST_ROWS(10) */ in Oracle can be inserted as follows:
UPDATE /*+ FIRST_ROWS(10) */ MyView
SET Col1 = 2
WHERE Col1 = 0
- After Table Options - Inserts options after the target table name. For example, the PARTITION option in Oracle can be inserted as follows:
UPDATE MyTable PARTITION(MyPartition)
SET Col1 = 2
WHERE Col1 = 0
- After Code Options - Inserts options after the end of the standard UPDATE statement. For example, the OPTION clause in SQL Server can be inserted as follows:
UPDATE MyTable
SET Col1 = 2
WHERE Col1 = 0
OPTION (hint1, hint2)
- Include space before options - Specifies that the space before the inserted options is included in the insertion.