SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
SA Pro: Constraint Autocomplete

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
SA Pro: Constraint Autocomplete
Author Message
Mindflux



Joined: 25 May 2013
Posts: 861
Country: United States

Post SA Pro: Constraint Autocomplete Reply with quote
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 View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 861
Country: United States

Post Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7993

Post Reply with quote
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 View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 861
Country: United States

Post Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7993

Post Reply with quote
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 View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
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


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.