 |
SoftTree Technologies
Technical Support Forums
|
|
| Author |
Message |
Mindflux
Joined: 25 May 2013 Posts: 861 Country: United States |
|
SA Pro: Constraint Autocomplete |
|
Can you help me figure out why when I want to DROP CONSTRAINT the only constraint it seems to show is the PK constraint? I am unsure which MSSQL Database Query to examine.

|
|
| Mon Nov 03, 2025 8:24 am |
|
 |
Mindflux
Joined: 25 May 2013 Posts: 861 Country: United States |
|
|
|
I found the table objects query and the default constraint query at the top.
When I run that without the where clause, I do see my constraint I'm trying to drop in there.
*Edit: Oddly this query doesn't show any of the PK constraints, which is the only thing the autocomplete is giving me. So maybe I'm in the wrong spot.
|
|
| Mon Nov 03, 2025 8:38 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7993
|
|
|
|
I think this is based on what is fetched by Columns (MSSQL) + Keys
First thing to check whether "Columns (MSSQL)" or "Columns (MSSQL) + Keys" query is selected in the options SQL Assistance -> SQL Server -> DB Queries. Or alternatively to see if columns in various popups that are part of primary, foreign, or unique keys are shown with a little key icon in front of them.

|
|
| Mon Nov 03, 2025 9:41 am |
|
 |
Mindflux
Joined: 25 May 2013 Posts: 861 Country: United States |
|
|
|
The columns is set to COLUMNS + Keys.
This is a default constraint I'm trying to autocomplete for, not a PK or FK.
|
|
| Mon Nov 03, 2025 9:42 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7993
|
|
|
|
Default constraints aren't currently covered by that feature. They aren't stored in the internal cache, and changing the Columns query won't help with that.
|
|
| Wed Nov 05, 2025 1:51 am |
|
 |
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|
|