Steven,
>Can someone help me with SQL syntax, commands, and procedures, using VFP 6.0 to add databases, tables, and access to them on SQL server?
Given enough rights to SQL you can run CREATE TABLE commands via SPT. If you have a lot of data to upload it's best done with the BCP utility that comes with SQL. You'll need to look at the SQL Books Online to give you syntax which does differ from the VFP equivalents.
You can also do the table creates from Query Analyzer or SQL Enterprise Manager.