T-SQL Script to Delete All The Relationships Between A Bunch Of Tables in a Schema and Other Bunch i
- by Galilyou
Guys,
I have a set of tables (say Account, Customer) in a schema (say dbo) and I have some other tables (say Order, OrderItem) in another schema (say inventory). There's a relationship between the Order table and the Customer table. I want to delete all the relationships between the tables in the first schema (dbo) and the tables in the second schema (inventory), without deleting the relationships between tables inside the same schema.
Is that possible? Any help appreciated.