I am using Azure SQL databases and am having trouble with setting up foreign keys. I get the message "The selected table engine () does not support foreign keys. I have looked in the options but the engine selection is blank and gray, as well as many of the other options. I know that foreign keys are supported since I can set them up via the Visual studio database editor. It is just so slow and hard to use that I would really like to be able to use HeidiSQL.
Any help is appreciated and if you need any troubleshooting or details from me just let me know.
Azure engine and foreign keys
Please login to leave a reply, or register at first.