Path: news.easynews.com!easynews!news-out.cwix.com!newsfeed.cwix.com!news.maxwell.syr.edu!bnewspeer01.bru.ops.eu.uu.net!bnewspost00.bru.ops.eu.uu.net!emea.uu.net!not-for-mail From: "Niall Litchfield" Newsgroups: comp.databases.oracle.server References: Subject: Re: SQL Sytax between Oracle & SQL Server Date: Wed, 10 Oct 2001 14:49:20 +0100 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Lines: 57 Message-ID: <3bc451e9$0$8509$ed9e5944@reading.news.pipex.net> NNTP-Posting-Host: host9.audit-commission.gov.uk X-Trace: 1002721769 reading.news.pipex.net 8509 193.128.236.219 X-Complaints-To: abuse@uk.uu.net Xref: easynews comp.databases.oracle.server:120814 X-Received-Date: Wed, 10 Oct 2001 07:38:16 MST (news.easynews.com) 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" wrote in message news:NxXw7.9943$hJ6.626408@news1.cableinet.net... > Does anyone know the syntax for DROP TABLE table_name CASCADE CONSTRAINTS in > SQL Server? > > Ta. > > Jason > >