distal-attribute
distal-attribute
distal-attribute
distal-attribute

Foreign Keys in SQL Server

Excessive posted 1 year 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?

Thanks!

ansgar posted 1 year 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 1 year 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 3 months ago

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

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