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

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.
Dave Pendleton
0

Comments

1 comment

Sort by
  • 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
    James R
    0

Add comment

Please sign in to leave a comment.