Tag Archives: mssql

Sql Server 2005, Sql Server 2008, Sql Server Tutorials

How to delete column that has a foreign key in MsSql

Scenario :  Delete a column that has a foreign key. Continue reading How to delete column that has a foreign key in MsSql →

Sql Server 2005, Sql Server 2008, Sql Server Tutorials

How to create a foreign key in MsSql

Scenario : We have two tables 1 Customers 2 Sales

I have to make sure that all the client id's that are inserted in the Sales table exists in the Client table Continue reading How to create a foreign key in MsSql →