Check if table exist using SQLite-PCL in a UWP Check if table exist using SQLite-PCL in a UWP sqlite sqlite

Check if table exist using SQLite-PCL in a UWP


You could execute a query:

SELECT name FROM sqlite_master WHERE type='table' AND name='MovieId';

by doing

var tableExistsQuery = "SELECT name FROM sqlite_master WHERE type='table' AND name='MovieId';"var result = conn.ExecuteScalar<string>(tableExistsQuery);