Foreign Keys in SQL Server

Excessive posted 2 years ago in General

I just started to use HeidiSQL, and it is instant love.

I'm using SQL Server 2005 on my server. When I try to create a table, I can create primary keys and generic fields, but I can't define foreign keys. The area used for defining foreign keys is empty.

Is this feature missing? Or do I miss something?


ansgar posted 2 years ago

HeidiSQL is traditionally more a MySQL client, and quite a few features still don't work in MSSQL mode. You can report them here, but it's unlikely that I can fix them, due to my lack of knowledge about MSSQL.

Excessive posted 2 years ago

It's one of the best organized and think-fully designed software out there.

Thank you very much for your support. Without the foreign keys functionality, its still extremely useful for me.

I can create foreign key constraints by using SQL anyway.

Thanks again!

Froschkoenig84 posted 12 months ago

This also important for me. If it's possible, tell us!

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