Datagrip Intellisense for Database Schema
For our SQL Server database on Datagrip, Intellisense keeps suggesting schemas that are not introspected or imported. We only use one schema (dbo) but it suggests everything under the sun and is not learning that I NEVER want to select a different one. Is there any way to force which schema should be completed with Intellisense?
请先登录再写评论。
May I know what are your settings in Suggest Objects from found in the following menu section: File | Settings | Editor | General | Code Completion
DataGrip 2024.2.2
Build #DB-242.21829.162, built on August 29, 2024
Licensed to *** Brandon Hessler
Subscription is active until November 28, 2024.
Runtime version: 21.0.3+13-b509.11 aarch64 (JCEF 122.1.9)
VM: OpenJDK 64-Bit Server VM by JetBrains s.r.o.
Toolkit: sun.lwawt.macosx.LWCToolkit
macOS 14.7.1
GC: G1 Young Generation, G1 Concurrent GC, G1 Old Generation
Memory: 4096M
Cores: 10
Metal Rendering is ON
Registry:
ide.experimental.ui=true
i18n.locale=
Non-Bundled Plugins:
com.andrey4623.rainbowcsv (2.0.2)
org.jetbrains.plugins.yaml (242.21829.162)
aws.toolkit.core (3.34-242)
com.vecheslav.darculaDarkerTheme (1.2.0)
Statistic (4.3.2)
com.intellij.ml.llm (242.21829.196)
izhangzhihao.rainbow.brackets (2024.2.6-241)
com.github.copilot (1.5.27.7265)
aws.toolkit (3.34-242)
You have mostly system schemas in your list. Please check if you have the following 2 checkboxes at the bottom unchecked
Please also check if use pre-introspected objects option is disabled in your data source properties
https://www.jetbrains.com/help/datagrip/schemas.html#use-pre-introspected-data-for-the-selected-system-catalog
I don't have those checkboxes available in my version.
I was messing around with the code completion settings and found this worked. It still suggests everything but it at least suggests `dbo` first (which is the only one we use).
With that change, it is working for me as of now, thank you so much for your help!