Posts
Sort by recent activity
Joins should only include reasonable columns
If I join
tableA
join tableB
on <-- the list pops up again
This list should only contain columns from tableA and or tableB. And it should prefer a foreign key that the table shares, a column they...
Need to filter objects on schema name
If I type:
select *
from schemaName.
The list needs to be filtered to only objects in that schema, otherwise I still have to hunt through tons of objects (including sys. objects, which was what ...
Schema name displayed in the prompt list
Schema name needs to show in the list. I have databases with several schemas, and right now even the sys. objects show in the list and things get jumbled
A toggle to show or not show could be good ...
Problems with duplicate object name in different schema
--in tempdb, I created the following objects (the refactor tool added the
--brackets, which I would prefer not to see
create schema bob
go
create schema bob2
go
create table [bob].[tableName]
(
co...
Shouldn't qualify names of objects that you cannot find.
For example, if I go to the master databse and put:
select *
from product
it changes it to:
select *
from [dbo].[product]
Neither of which will work. Also, in adventureWorks, if I say qualify nam...
Bug with LayOut SQL.
The following error:
Document Contains Invalid SQL Syntax
SQL Refactor was unable to lay out this file because some errors were found while it was being parsed. These errors have been highlighted....