Author |
Message |
hitesh
Joined: 15 Oct 2007 Posts: 104
|
|
Suggestions: SQL Code Complition |
|
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 |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7951
|
|
|
|
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 |
|
 |
hitesh
Joined: 15 Oct 2007 Posts: 104
|
|
|
|
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 |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7951
|
|
|
Wed Jul 30, 2008 9:53 am |
|
 |
|