How to Drop Foreign Key Constraint in SQL Server Database - SQL Server / TSQL Tutorial Part 75

preview_player
Показать описание
SQL Server / T-SQL Tutorial Scenario:
You are working as SQL Server developer and you need to prepare the script to drop the Foreign Key Constraint which was created on dbo.Orders table.

Link to scripts used in SQL Server / TSQL Tutorial Video

Check out our website for Different SQL Server, MSBI tutorials and interview questions
such as SQL Server Reporting Services(SSRS) Tutorial
SQL Server Integration Services(SSIS) Tutorial
SQL Server DBA Tutorial
SQL Server / TSQL Tutorial ( Beginner to Advance)
Рекомендации по теме
Комментарии
Автор

I dropped all the tables... except one that had FK..but when I check key ..there is no FK ..now i can't delete the table ...pls help ...

sumeetpatil