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

Format SQL and ALTER TABLE

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.
MikeyC
0

Comments

2 comments

Sort by
  • Anu D
    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.
    Anu D
    0
  • jmcaleer
    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! :(
    jmcaleer
    0

Add comment

Please sign in to leave a comment.