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

Formatting GRANT

Hi!

Wanted to inquire, does Redgate's MRQD formatting standard supports formatting aligned GRANT statements.

E.g. given

GRANT INSERT ON SCHEMA :: firstSchema TO ReadRole WITH GRANT OPTION
GRANT INSERT ON SCHEMA :: veryLongSchemaName TO ReadRole WITH GRANT OPTION

I'd like it to be formatted with aligned

GRANT INSERT ON SCHEMA :: firstSchema           TO ReadRole WITH GRANT OPTION
GRANT INSERT ON SCHEMA :: veryLongSchemaName TO ReadRole WITH GRANT OPTION

Similar to datatypes and nulls for tables.

On quick and not so quick look at settings, it doesn't seem possible.

Best regards,
Jānis
 

Jānis Goldmanis
0

Comments

1 comment

Sort by
  • Christian Perez
    Official comment

    Hello Jānis,

    Hope you are doing well today, thanks for reaching out to Redgate Support regarding your Prompt formatting question. I took the SQL examples you provided and I attempted to format them and get the TO ReadRole to right-align, but I was also unsuccessful, so I am leaning towards agreeing with you that this is not possible at the moment.

     

    In which case the best avenue for you would be to create an entry on Prompts User Voice page to see if we could get this implemented in a future version of Prompt. Topics created on our User Voice forum are voted on by other Prompt/Redgate Users and utilized to determine what features to add to our products. Here is the link: https://redgate.uservoice.com/forums/94413-sql-prompt

     

    Let me know if you have any other comments or concerns.

    Christian Perez

Add comment

Please sign in to leave a comment.