Error Msg 547

Hi,
I'm not an expert in SQL, I just need it to run a Blackberry server.
I need to run this follwing command to clear the database :
delete from mdsagconfig
But it does not work and I receive the following message :
Msg 547, Level 16, State 1, Server XXXX, Line 1
DELETE statement conflicted with COLUMN REFERENCE constraint
'FK_ServerConfig_MDSAGConfig' . The conflict occurred in database 'DataBase
Name', table 'ServerConfig', column 'MDSAGConfigId'.
The statement has been terminated.
Any idea ?
--
MerciYou have a foreign key defined on column MDSAGConfigId in table ServerConfig
that references a column in table MDSAGConfig, and you are trying to delete a
row from MDSAGConfig with a dependent row in ServerConfig. You can delete the
row in ServerConfig first, then delete the row from MDSAGConfig.
Linchi
"Chelims" wrote:
> Hi,
> I'm not an expert in SQL, I just need it to run a Blackberry server.
> I need to run this follwing command to clear the database :
> delete from mdsagconfig
> But it does not work and I receive the following message :
> Msg 547, Level 16, State 1, Server XXXX, Line 1
> DELETE statement conflicted with COLUMN REFERENCE constraint
> 'FK_ServerConfig_MDSAGConfig' . The conflict occurred in database 'DataBase
> Name', table 'ServerConfig', column 'MDSAGConfigId'.
> The statement has been terminated.
> Any idea ?
> --
> Merci