<div>
If i remove the foreign key constraint, what will happen to the rest of my records in the dbase?
</div>


If i remove the foreign key constraint, what will happen to the rest of my records in the dbase?

<div>
Do i really need foreign key constraints in the first place?
</div>


Do i really need foreign key constraints in the first place?

<div>
appbuilder,<br />
<br />
FK as for implementing Referential integrity:) <br />
<br />
<br />
Aneesh R<br />

</div>


appbuilder,

FK as for implementing Referential integrity:)


Aneesh R


<div>
<div class="content wysiwyg-content">
Greeting everyone.<br />
<br />
I cant seem to find my way through this issue. <br />
<br />
I have 2 tables in my dbase that are related:<br />
<br />
tbl_ticket (fk)<br />
tbl_location(pk)<br />
<br />
These tables are related by locationID<br />
<br />
Some companies my dbase have multiple locations others dont! &nbsp;So when i run an INSERT query the companies with multiple locations work fine. But, when i try to run the INSERT query from a company with no locations i get the following error message:<br />
<br />
<br />
The INSERT statement conflicted with the FOREIGN KEY constraint &quot;FK_tbl_ticket_tbl_locatio<wbr />n&quot;. &nbsp;<br />
<br />
What would you suggest i do in this instance...?<br />
<br />
I presume im trying to insert and ticket and not associating a location to the newly created ticket but for the company with no location NONE exist. What should i do to work around this?<br />

</div>
</div>


Greeting everyone.

I cant seem to find my way through this issue. 

I have 2 tables in my dbase that are related:

tbl_ticket (fk)
tbl_location(pk)

These tables are related by locationID

Some companies my dbase have multiple locations others dont!  So when i run an INSERT query the companies with multiple locations work fine. But, when i try to run the INSERT query from a company with no locations i get the following error message:


The INSERT statement conflicted with the FOREIGN KEY constraint "FK_tbl_ticket_tbl_location".  

What would you suggest i do in this instance...?

I presume im trying to insert and ticket and not associating a location to the newly created ticket but for the company with no location NONE exist. What should i do to work around this?


The INSERT statement conflicted with the FOREIGN KEY constraint &quot;FK_tbl_ticket_tbl_location&quot;.

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

The INSERT statement conflicted with the FOREIGN KEY constraint &quot;FK_tbl_ticket_tbl_location&quot;.

The INSERT statement conflicted with the FOREIGN KEY constraint "FK_tbl_ticket_tbl_location".