Difference between revisions of "TABLEEXISTS()"
From Lianjapedia
(Created page with '==Purpose== Function to check whether table exists ==Syntax== TABLEEXISTS(<expC1>, <expC2>) ==See Also== CLOSE DATABASES, CREATE DATABASE, DATABASE(), [[DATABASEEXI…') |
|||
Line 6: | Line 6: | ||
==See Also== | ==See Also== | ||
− | [[CLOSE DATABASES]], [[CREATE DATABASE]], [[DATABASE()]], [[DATABASEEXISTS()]], [[DBC()]], [[DBF()]], [[FILE()]], [[OPEN DATABASE]], [[USE]], [[USED()]] | + | [[CLOSE DATABASES]], [[COLUMNEXISTS()]], [[CREATE DATABASE]], [[DATABASE()]], [[DATABASEEXISTS()]], [[DBC()]], [[DBF()]], [[FILE()]], [[OPEN DATABASE]], [[USE]], [[USED()]] |
==Description== | ==Description== |
Revision as of 05:53, 22 November 2012
Contents
Purpose
Function to check whether table exists
Syntax
TABLEEXISTS(<expC1>, <expC2>)
See Also
CLOSE DATABASES, COLUMNEXISTS(), CREATE DATABASE, DATABASE(), DATABASEEXISTS(), DBC(), DBF(), FILE(), OPEN DATABASE, USE, USED()
Description
The TABLEEXISTS() function returns .T. if the table name specified in <expC2> exists in the database specified in <expC1> and .F. otherwise.
Example
if tableexists("southwind","customers") open database southwind use customers else open database southwind create table customers (...) endif