Joined: 23 May 2012 Posts: 1 Country: United States
How to add schema name in front of Table name ?
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 ?
I want this : SELECT id FROM dbo.STUDENTS
I don't want: SELECT s.id FROM STUDENTS s
Wed May 23, 2012 10:05 pm
Joined: 11 Mar 2010 Posts: 399 Country: Hungary
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?
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