Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 regarding deleting

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-02-02 : 17:52:00
mohamed iqbal writes "Sir,

I am using MS-SQL server 7.0

I want to delete the records in the database which is refered by many tables (Foreign Key).

Please give reply back

Just I also want to know is there any provision in SQL server like ondelete cascade in ORACLE(by giving this command in oracle while creating database , if we delete the row of primary key in one table then values referred by (foreighn keys) in all the databases will be deleted automatically).

Thanking you
IQbal"
   

- Advertisement -