How to add schema name in front of Table name ?

Hi,

How can I add schema name ( eg dbo ) in front of the Table name and how to remove the Table Alias by default for single table query ?

Eg:
I want this : SELECT id FROM dbo.STUDENTS

I don't want: SELECT s.id FROM STUDENTS s

There are two settings on Options -> DB Options tab:
1. Always Fully Qualify Object Names and
2. Auto Add Aliases

By setting #1 to "With schema name" you'll always have object names inserted by SA qualified by their schema name. For existing queries you can try Refactoring->Qualify Object Names from SQL Assistant context menu, though it tends to be somewhat... unreliable.

AFAIK, there is no feature for removing aliases yet but for not adding them in queries generated by SA you can set #2 to No.

Just out of curiosity, are there any reasons other than personal preferences that you want aliases to be removed?