[Feature request] Check Constraints in Structure View

[vpoguru]

1. Which driver are you using and version of it (Ex: PostgreSQL 10.0): SQLite 3.27.2 / PostgreSQL 11.x / MySQL 8.x / ...

2. Which TablePlus build number are you using (the number on the welcome screen, Ex: build 81): Version 2.2 (217)

3. The steps to reproduce this issue:

Noted: If the bug is related to data, please attach an example SQL data.

It would be awesome if check constraints could be added to the table structure view (e.g. column_name, data_type, is_nullable, column_default, foreign_key, check_constraint). Currently, check constraints are only shown in the table definition pane.

[huyphams]

Thank you @chrschmitz I've got a plan to improved view support:

• Indices
• Constraint
• Edit view content.

[stnwk]

Would love that too!

[surfsnowpro]

Recently purchased a license for myself and am getting my company to purchase licenses as this is now my go-to tool. This is one feature that would make my life a lot easier. Is this in the works?

[jareware]

Was looking for this just today, 👍 for usefulness!

[spolloni]

+1

[mariusjp]

A very important feature request left open for 3 years...

[spikebrehm]

I hate to be that guy, but... this would be supppper useful! +1

[matthew-kerle]

This would be really helpful, still. 👍

[jobarjo]

up!

[cdignas]

would be great!

[bwkiefer]

+1

[Zerebokep]

bump

[pags]

+1 please add a way to view check constraints

[shadoath]

Hi @huyphams, I'm going to bump this thread. There is a lot of interest in having this feature. It caught me trying to make a bad update to our DB because I could not see the names of the constraints that were in place.