how to find the name of database in use

using the DISPLAY DATABASE command, I would say:
http://msdn.microsoft.com/en-us/library/aa977571%28v=vs.71%29.aspx

As others have indicated above, the Database in Use is quite different than the Data Table in Use.

If you really mean Database then you have your answer above.
If you meant to indicate Data Table, let us know.

Good Luck

Yes, b001, if you talk about the table, let us know, but I can answer that upfront, too, and jrbbldr could have added that, already:
DBF(), as easy as DBC() this gives the full file name of the currently selected DBF.

Also see ALIAS(), if the alias name is of interest only, and AUSED(laTables) gives you an array of open dbfs or cursors, views, etc. of the current datasession.

Bye, Olaf.

And... at the end it is necessary to mention:

The latest VFP 9 SP2 help file is available here: http://vfpx.codeplex.com/

:-)