Competition: What’s your favorite Redgate tool? Enter now.

Format SQL and ALTER TABLE

CodantiMCodantiM Posts: 245
edited July 1, 2011 9:21AM in SQL Prompt Previous Versions
I am using SQL Prompt 4.0.4.14 and have found that the Format SQL doesn't like the ALTER TABLE queries much:
ALTER TABLE msdb.dbo.backupfile 
	ADD Test VARCHAR(10) NULL;

Becomes:
ALTER TABLE msdb.dbo.backupfile 
ADD Test VARCHAR(10) NULL ;

Also:
ALTER TABLE msdb.dbo.backupfile 
	ALTER COLUMN x VARCHAR(192);

Becomes:
ALTER TABLE msdb.dbo.backupfile 
ALTER COLUMN x VARCHAR(192) ;

Appears to be the same issue that keeps coming up with things like ALTER VIEW.

Comments

  • Anu DAnu D Posts: 876 Silver 3
    Many thanks for your post and apologies for the inconvenience caused.

    I have already logged this issue in our internal tracking system and added your comments to it.

    Tracking Id for this issue is SP-2945 our developers will look into this and fix it in future release.

    I will update you as soon as it is fixed.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: [email protected]
  • The problem is still there in SQL Prompt 5! It won't even attempt to format a multiple column add. It just left justifies it! :(
Sign In or Register to comment.