Hello there,

I was wondering if anyone knew if it were possible to make sql server 2005
cascade field name changes down into dependant views.

For example if I have a table
table1
- id
- title

and a view
view1
select id from table1

Can I somehow make it so that if I change table1.id to table1.myId the view
will automatically update?

Kinda just the same way MS-Access does it. That'd be neat.

Thank you kindly for any ideas
John Sheppard