Red Gate forums :: View topic - Format SQL and ALTER TABLE
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt Previous Versions
SQL Prompt Previous Versions forum

Format SQL and ALTER TABLE

Search in SQL Prompt Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
CodantiM



Joined: 29 Jun 2007
Posts: 182

PostPosted: Tue Mar 30, 2010 6:45 pm    Post subject: Format SQL and ALTER TABLE Reply with quote

I am using SQL Prompt 4.0.4.14 and have found that the Format SQL doesn't like the ALTER TABLE queries much:

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


Becomes:

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


Also:

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


Becomes:

Code:
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.
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 691
Location: Cambridge

PostPosted: Thu Apr 01, 2010 9:31 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
jmcaleer



Joined: 01 Jul 2011
Posts: 1

PostPosted: Fri Jul 01, 2011 2:21 pm    Post subject: Still not fixed in SQL Prompt 5 Reply with quote

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! Sad
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group