Sergey,
One observation about the INFORMATION_SCHEMA views is that the field list doesn't match the actual view. There are more rows in the INFORMATION_SCHEMA than fields in the view and AS information isn't available. It looks like I have to get to the SQL statement to get this stuff.

Gary


>Hi Gary,
>
>The INFORMATION_SCHEMA views is the first place to look for SQL Server metadata. The system stored procedures would be the second. I strongnly recomend never access system tables directly in application because MS doesn't guaranty that they wouldn't change them in the next version of MS SQL Server.
>
>>Most Excellent! That saves me from a considerable parsing exercise.
>>