Format SQL and ALTER TABLE

MikeyC

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.

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.

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!