create database MyViews create SQL View "SomeView" AS ; Select Table1.Field1, Table1.Field2, Table2.Field1 ; FROM Table1 ; INNER JOIN Table2 on Table1.Field1 = Table2.Field1 ; WHERE SomeConditionWhen you're done, you can delete the whole thing:
SET DATABASE TO MyViews CLOSE DATABASE DELETE FILE MyViews.dbc DELETE FILE MyViews.dc?