Installation guide

select name from syscolumns
where id = object_id("employees")
3.
Compare the output of the two queries by running sp_help on both the view and the tables
that comprise the view.
This comparison works only for views, not for other compiled objects. To determine
whether select * statements in other compiled objects need to be revised, review the source
text of each compiled object.
If the table contains more columns than the view, retain the preupgrade results of the select
* statement. Change the select * statement to a select statement with specific column
names.
4.
If the view was created from multiple tables, check the columns in all tables that comprise
the view and rewrite the
select
statement if necessary.
CHAPTER 10: Adaptive Server Upgrades
104 Adaptive Server Enterprise