CODEWITHSUNDEEP
azure-sql-databasessmsheidisql
CBreeze
CBreeze

Reputation: 2965

Unable to view foreign keys in SQL

I am having issues with importing data into SQL using HeidiSQL. I have a really basic table that looks like so:

enter image description here

It has an Index on it that looks like so:

enter image description here

For some reason in HeidiSQL I cannot look at the Foreign Key tab:

enter image description here

But then I have no issue looking/creating these in SSMS:

enter image description here

HeidiSQL seems to get confused and will not let me look at the Foreign Key tab however SSMS has no such issue.

Upvotes: 0

Views: 51

Answers (1)

Caius Jard
Caius Jard

Reputation: 74605

Looks like HeidiSQL doesn't support a few aspects of foreign keys when using Azure SQL; this guy was complaining about it two years ago: https://www.heidisql.com/forum.php?t=19139

enter image description here

Note the exact same error message as shown in your HS screenshot..

Kinda disappointing that it's been an issue for so long!

Upvotes: 1

Related Questions