Intellisense for $partition.<partition_functions>

PawJ

Im missing Intellisense for working with partitioning in SQL Server.

I would like the Prompt to be able to list any partition function found in the current context (DB)
like when i write: $partition.<Intellisense here>

is this possible ?

Thanks in advance

Jon_Kirkwood

Hi @PawJ
 
Thanks for reaching out on the Redgate forums regarding this inquiry.
 
Unfortunately, it does not appear to be a current function of SQL Prompt to expand on custom partition functions like that. 
It will highlight the function in your code but doesn't load suggestions.
 
Intellisense will trigger from statements so if you have a statement such as ALTER PARTITION FUNCTION then I would anticipate your functions to appear.
 
 

 
 
I could suggest leaving a feature request on our UserVoice page for our development team to potentially implement this functionality into SQL Prompt
Our feature request page for SQL Prompt can be found here:
https://redgate.uservoice.com/forums/94413-sql-prompt/
 
If you do post a request on the UserVoice site please advise here so I can link them and ensure appropriate escalation within our product teams.

PawJ

Hey Jon

Just posted this on uservoice: IntelliSense for $partition. – Customer Feedback for Redgate (uservoice.com)

Jon_Kirkwood

Excellent, thank you for doing that and updating this post with the link

I'll ping it internally with our development team to ensure there is some awareness on it.