Quote:
But there are some unessary aliasing created by the machine generated code, so I need to delete blocks of code from the source script to get a decent SQL code.
Trully? I don't believe you can clean up your SQL code (query) by removing aliases. Aliases are very important in SQL. See:
SQL Server: ALIASES[
^]. I prefer to use aliases, due to more human-readable form of sql code, for example:
Without aliases version:
SELECT [dbo].[DatabaseName1].[FirstTableName].[Column1], [dbo].[DatabaseName2].[SecondTableName].[Column5], ...
FROM [dbo].[DatabaseName1] INNER JOIN [dbo].[DatabaseName2] ON [dbo].[DatabaseName1].[FirstTableName].PrimaryKey = [dbo].[DatabaseName2].[SecondTableName].ForeignKey
WHERE [dbo].[DatabaseName1].[FirstTableName].[Column2]='Whatever'
With aliases version:
SELECT A.[Column1], B.[Column5], ...
FROM [dbo].[DatabaseName1].[FirstTableName] AS A INNER JOIN [dbo].[DatabaseName2].[SecondTableName] AS B ON A.PrimaryKey = B.ForeignKey
WHERE A.[Column2]='Whatever'
My advice: Stop looking for tool, buy a book and learn about SQL!