Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL Sytax between Oracle & SQL Server
from the sql server (2000) help manual it looks as if the cascade constrains
functionality is not available.
DROP TABLE
Removes a table definition and all data, indexes, triggers, constraints, and
permission specifications for that table. Any view or stored procedure that
references the dropped table must be explicitly dropped by using the DROP
VIEW or DROP PROCEDURE statement.
Syntax
DROP TABLE table_name
Arguments
table_name
Is the name of the table to be removed.
Remarks
DROP TABLE cannot be used to drop a table referenced by a FOREIGN KEY
constraint. The referencing FOREIGN KEY constraint or the referencing table
must first be dropped.
Incidentally I was trying to check up on my memory of cascade constraints (I.e. it drops foreign keys as well) when iIgot
ORA-30554: function-based index TAHITI.SQL_KEYWORD_INDEX is disabled ORA-06512: at "TAHITI.SQL_KEYWORDS", line 94 ORA-06512: at line 7
ah well
-- Niall Litchfield Oracle DBA Audit Commission UK "Jason Heaton" <jase74_at_hotmail.com> wrote in message news:NxXw7.9943$hJ6.626408_at_news1.cableinet.net...Received on Wed Oct 10 2001 - 08:49:20 CDT
> Does anyone know the syntax for DROP TABLE table_name CASCADE CONSTRAINTS
in
> SQL Server?
>
> Ta.
>
> Jason
>
>