SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Suggestions: SQL Code Complition

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Suggestions: SQL Code Complition
Author Message
hitesh



Joined: 15 Oct 2007
Posts: 79

Post Suggestions: SQL Code Complition Reply with quote
Suggestions # 1
===========
When I type following line of code, SQL Assi does not list out all COLUMNS name for a table after ALTER COLUMN statement.

ALTER TABLE EMPLOYEE_MASTER ALTER COLUMN ...
ALTER TABLE EMPLOYEE_MASTER DROP COLUMN ...

Suggestions # 2
===========
When I type following line of code, SQL Assi does not list out all CONSTRAINTS name for a table after ALTER CONSTRAINTS statement.

ALTER TABLE EMPLOYEE_MASTER ALTER CONSTRAINT...
ALTER TABLE EMPLOYEE_MASTER DROP CONSTRAINT...

Suggestions # 3
===========
Pl highlight PRIMARY KEY COLUMN(S) for a given table in diff color in dropdown list

That's all at the moment!
SQL Assistant is my "all time favorite tool!" after VS2008
Wed Jul 30, 2008 9:35 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6484

Post Reply with quote
Hi,

Thanks for your suggestions. SQL Assistant currently doesn't support column/constraint/index/default and other types of context elements in ALTER TABLE/VIEW/etc... types of statements. This is one of the areas where we can improve in future versions.
Wed Jul 30, 2008 9:40 am View user's profile Send private message
hitesh



Joined: 15 Oct 2007
Posts: 79

Post Reply with quote
it would be great if you can list out all KEYWORDS w.r.t CREATE/ALTER/DROP statement. (alought this can be configured in options window)
Wed Jul 30, 2008 9:48 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6484

Post Reply with quote
Please take a look at http://www.softtreetech.com/support/phpBB2/viewtopic.php?t=22428. Maybe that will help.
Wed Jul 30, 2008 9:53 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
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
Design by Freestyle XL / Flowers Online.