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

2 comments

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
  • laurarobinette

    Thanks for raising this feature request. Supporting alternative CREATE VIEW syntax would definitely improve compatibility with newer SQL dialects and reduce the need for manual edits during deployments. It would make the tooling more flexible for teams working across different database versions and help streamline existing workflows. I appreciate it and bad time simulator.

    laurarobinette
    0

Add comment

Please sign in to leave a comment.