Dowt in view - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Dowt in view

Author

Topic

iswan
Starting Member

28 Posts

Posted - 2007-06-09 : 02:54:18

1. I Created the table Project(PHID,PName,PNo),Dept(PID0,DName,DNo)

2. I Created the view By Using the below code

CREATE VIEW dbo.scViewJoinscFormTabs AS SELECT * FROM (SELECT * FROM Project a FULL OUTER JOIN Dept a0 ON a.PHID = a0.PHID0) v
3. IF I Fetch the view. I am getting Fields(PHID,PName,PNo,PID0,DName,DNo)

4. Then add the new Field(PL) in Project. Now Table is changed like Project(PHID,PName,PNo,PL).

5. Now I fetch the view. The new added field is not coming

Query: select * from dbo.scViewJoinscFormTabs

getting output field: (PHID,PName,PNo,PID0,DName,DNo)

expeted output field: (PHID,PName,PNo,PL,PID0,DName,DNo)
Regards

Iswan

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-06-09 : 04:12:23

I think you need to alter the view

ALTER VIEW dbo.scViewJoinscFormTabs AS SELECT * FROM (SELECT * FROM Project a FULL OUTER JOIN Dept a0 ON a.PHID = a0.PHID0) v

Now query

select * from dbo.scViewJoinscFormTabs

and see what it returns

Also it is better practice to specify column names than using *

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources