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

aakims

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! 

Dan_J

Hi @aakims
 
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.