Colored Keys

jesus-rangel's profile image jesus-rangel posted 2 years ago in General Permalink

I'm sorry if this has been asked before but I've done a search here and found something about colored diamonds.

Next to the field of the tables in Heidi I see a yellow key, a green key and sometimes a red key.

Could someone please tell me what the colors mean?

Thanks in advance and have a good day.

ansgar's profile image ansgar posted 2 years ago Permalink
  • yellow = primary key
  • red = unique key
  • green = normal index
  • dark blue = fulltext index
  • light blue = spatial/geometry key

The key type is also displayed in the "Indexes tab":

Description

jesus-rangel's profile image jesus-rangel posted 2 years ago Permalink

Thank you very much!

Please login to leave a reply, or register at first.