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 &#91;dbo&#93;.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 &#91;dbo&#93;.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 July 21, 2009 16:03

Comments

1 comment

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 July 28, 2009 07:02

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Incorrectly formatted view

Comments

Add comment