iterating tables

[frank ashley]

How do i retrieve all the table names (except the schema ones) from sql server 7

I can't find an equivalent to cn.openschema

[JHausmann]

Run the stored procedure sp_help without a parameter.