Hi Bill,

Thanks, SQLDMO seems to be exactly what I need. It just didn't come to my immediate mental. Just starting to play with all this SQL Server stuff.

Aloha,

James
>>Hi All,
>>
>>Is there a way to get a list of table names from a SQL database? What about stored procedures?
>>
>>Thanks in advance for any help.
>>
>>Aloha,
>>
>>James
>
>Hi James -
>take a look at the sqltables() function in vfp ?
>Aslo - the DMO can be directly accessed in VFP and you can retrieve all SP info from there ...
>hth - mondo regards [Bill]