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

Redgate SQL Prompt for ADS formatting style for "create/alter as"

Thanks for making SQL Prompt available for ADS users! I've been able to customize all of the available styling variables to my preference except for one. I cannot find an option to keep "as" on the same line when creating/altering objects like views/procedures/functions.

How Redgate currently formats: 
create [dbo].[view_name] 
as

select
...

I would like an option to format as:
create [dbo].[view_name] as 

select 
...

I'm using: 
Redgate SQL Prompt v0.2.12
ADS 1.42.0

If this is already an available option, please let me know how to enable this. Thanks!
Alana
0

Comments

1 comment

Sort by
  • Dan_J
    Hi @...
     
    Thanks for reaching out to us regarding this!
     
    I've attempted to achieve the formatting you are describing (keeping 'as' on the same line), however unfortunately this doesn't appear to be possible.
     
    I appreciate this would be useful functionality for you, however unfortunately SQL Prompt for ADS is no longer on the roadmap for further development and so I'm afraid this is unlikely to be changed at this time.
    Dan_J
    0

Add comment

Please sign in to leave a comment.