What are the challenges you face when working across database platforms? Take the survey
Options

Alternate CREATE VIEW syntax supported?

Some of use use (and support) an alternate CREATE VIEW syntax:
CREATE VIEW [dbo].[MyView] 
	( 
	ColumnOne, 
	ColumnTwo, 
	ColumnThree
	)
AS
	SELECT a, b, c FROM [dbo].[MyTable];

After formatting with SQL Prompt 8.0.1.1383, this is rendered as:
CREATE VIEW [dbo].[MyView] (ColumnOne,ColumnTwo,ColumnThree)
AS
SELECT  a, 
	b, 
	c 
FROM 	[dbo].[MyTable];
The formatting of the SELECT is as desired, but the reformatting of the CREATE VIEW is not desirable and I haven't found where to control this.

Is this supported?

Thanks all.
Tagged:

Comments

  • Options
    James RJames R Posts: 104 Silver 4
    edited June 5, 2017 11:04AM
    Hi again David,

    We should definitely be formatting the columns using the options on the DDL page, sorry! We've got a fix for the issue here and will hopefully have it released in the next few days. I've logged this internally as ticket SP-6362.

    Thanks!
    James
    Software Engineer
    Redgate Software
Sign In or Register to comment.