>How can I use VFP 6.0 to create a database and add tables to SQL Server?


Directly, you can't do it. Through SQL-DMO however, you can. You can also pass SQL-DDL to the server - assuming the user has the correct privledges.