Alternate CREATE VIEW syntax supported?

Dave Pendleton

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.

James R

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