How can we help you today? How can we help you today?

Intellisense for $partition.<partition_functions>

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
PawJ
0

Comments

3 comments

  • 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.
    Jon_Kirkwood
    0
  • PawJ
    PawJ
    0
  • 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.


    Jon_Kirkwood
    0

Add comment

Please sign in to leave a comment.