Descriptions for queries using select * are fully expanded to describe the columns selected. For example:
create procedure myproc as select * from authors
Produces the following in syscomments:
create procedure myproc as --Adaptive Server has expanded all '*' elements in the following statement select authors.au_id, authors.au_lname, authors.au_fname, authors.phone, autho rs.address, authors.city, authors.state, authors.country, authors.posta lco
| Copyright © 2004. Sybase Inc. All rights reserved. |
|
|
