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

Format SQL and ALTER TABLE

MikeyCMikeyC Posts: 249 Bronze 3
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

  • Options
    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: support@red-gate.com
  • Options
    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.