>can I use Microsoft SQL as back end and Visual foxpro without having to create table or database inside visual foxpro
>any help

You can use SQL Pass-Through (SPT) or/and ADO to access Sql Server from VFP. Take a look at DataClas/VFP, for example.