Comments
Sort by recent activity
No Problem - we just want to make it all work [image]
Here's an example, but it happens with just about all of the foreign keys and check constraints if the schema is not dbo:
ALTER TABLE [RxOrder].[LineItem] WITH CHECK ADD CONSTRAINT RxOrder.LineItem_Eye_Chk] CHECK (([Eye]='L' OR [Eye]='R'))
The RxOrder.LineItem_Eye_Chk] throws an error when run becuase of the second set of [] brackes in the name. / comments
No Problem - we just want to make it all work
Here's an example, but it happens with just about all of the foreign keys and check constraints if the schema is not dbo:
ALTER TABLE [RxOrder].[LineI...