Home News DOC Class DL Others Rice
Class  >  connection  >  ExistsTable(string)
connection class : ExistsTable(string) method

Description

Returns a value that indicates whether the table exists.

Syntax

instance.ExistsTable(string name)

Arguments

ClassNameDescription
stringnameTable name.

Return value

ClassDescription
boolWhether the table exists.

Sample code

1:

connection cnn = new connection("Data Source=c:\somedirectory\somedatabase.sqlite3;Version=3;");

2:

cnn.Open();

3:

bool exists = cnn.ExistsTable("tabelname");

4:

cnn.Close();

5:

cnn.Release();

Notes

Executes the following SQL statement and returns the result as bool.

select count(*) from sqlite_master where type='table' and name='tablename';

Links for reference

None.

Copyright © Rice All rights reserved.