RE: DELETE FROM table UNRECOVERABLE?

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Fri, 21 May 2004 10:54:34 -0700
Message-ID: <B5C5F99D765BB744B54FFDF35F60262109F87865@irvmbxw02>

>-----Original Message-----
>Thomas Jeff
>
>Would you know if DELETE UNRECOVERABLE is a valid statement in other
>databases, such as DB2 or
>SQL Server? Since the code is generic in nature in order to support
>portability, I wonder if=20
>perhaps this code originated from another database. The users said
>this was to be a truncate=20
>and load operation and I don't believe for a minute that UNRECOVERABLE
>is intended to be an=20
>alias.
>
>And, we can't remove the UNRECOVERABLE, it's code belonging to a
>purchased module.
 

Not in SQL Server. I don't know about DB2. From the SQL Server 2000 Books online:

DELETE
    [ FROM ]

        { table_name WITH ( < table_hint_limited > [ ...n ] )
         | view_name
         | rowset_function_limited
        }

        [ FROM { < table_source > } [ ,...n ] ]

    [ WHERE
        { < search_condition >
        | { [ CURRENT OF
                { { [ GLOBAL ] cursor_name }
                    | cursor_variable_name
                }
            ] }
        }

    ]
    [ OPTION ( < query_hint > [ ,...n ] ) ]

< table_source > ::=

    table_name [ [ AS ] table_alias ] [ WITH ( < table_hint > [ ,...n ] ) ]

    | view_name [ [ AS ] table_alias ]
    | rowset_function [ [ AS ] table_alias ]
    | derived_table [ AS ] table_alias [ ( column_alias [ ,...n ] ) ]
    | < joined_table >

< joined_table > ::=

    < table_source > < join_type > < table_source > ON < search_condition >

    | < table_source > CROSS JOIN < table_source >     | < joined_table >

< join_type > ::=

    [ INNER | { { LEFT | RIGHT | FULL } [OUTER] } ]     [ < join_hint > ]
    JOIN < table_hint_limited > ::=

    { FASTFIRSTROW

        | HOLDLOCK
        | PAGLOCK
        | READCOMMITTED
        | REPEATABLEREAD
        | ROWLOCK
        | SERIALIZABLE
        | TABLOCK
        | TABLOCKX
        | UPDLOCK

    }

< table_hint > ::=

    { INDEX ( index_val [ ,...n ] )

        | FASTFIRSTROW
        | HOLDLOCK
        | NOLOCK
        | PAGLOCK
        | READCOMMITTED
        | READPAST
        | READUNCOMMITTED
        | REPEATABLEREAD
        | ROWLOCK
        | SERIALIZABLE
        | TABLOCK
        | TABLOCKX
        | UPDLOCK

    }

< query_hint > ::=

    { { HASH | ORDER } GROUP

        | { CONCAT | HASH | MERGE } UNION
        | FAST number_rows
        | FORCE ORDER
        | MAXDOP
        | ROBUST PLAN
        | KEEP PLAN

    }

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri May 21 2004 - 12:52:21 CDT