>1) if we create application using either vb or vfp, then do we had to manually create the database/table in the sql server or vb/vfp had tool to help us with that.

To answer part of your question from http://msdn.microsoft.com/vstudio

*****************
Oracle and SQL Server Database Designer. Visual Studio 6.0 now offers integrated database design tools for Oracle (7.3.3 and higher) and Microsoft SQL Server (6.5 and higher) databases. Developers can visually design and modify database tables and relationships, and create stored procedures and database functions directly within the development environment. Remote stored procedure debugging is provided on SQL Server databases.
*****************