How can we help you today? How can we help you today?

Incorrectly formatted view

I am wondering if this is my system or if this is a larger issue. I select a view for example.
create view [dbo].EmployeeView
as
select 
XE.xEmployeeID
,XE.FirstName
,XE.LastName
from 
dbo.xEmployee as XE

if I try and format this it will not do anything.
If I comment out the create view part.
--create view [dbo].EmployeeView
--as
select
    XE.xEmployeeID
   ,XE.FirstName
   ,XE.LastName
from
    dbo.xEmployee as XE

It gets properly formatted.


Also just to note, is there any way for those suggested table names to be lower case?

Thanks

Adam
adam[dot]s[at]softworks[dot]ca
aseniuk
0

Comments

1 comment

Sort by
  • MikeONeill
    Have look under Options in The SQL Prompt 4 menu , you see Aliases half way down , there is a checkbox to capitalise Aliases , just uncheck it

    Mike
    MikeONeill
    0

Add comment

Please sign in to leave a comment.