Get Col Names

[pete.smith]

Hello

How can I look at the col names in a table? In particular, we are trying to get counts of files in the html table ( I think I Want that one) of each directory, like mysite.com/thisdir . I get strange results if I do the like %/thisdir% on the Url field.

[John]

You can select from SYSCOLUMNS to get column names.

That isn't the right syntax for LIKE though as it takes a metamorph query. You might want

Url like 'thisdir'
or
Url matches 'http://mysite.com/thisdir%'