Android Question sqlite_schema

MicroDrie said:

Something like this?

SQL:

SELECT
  name, type
FROM
  sqlite_master
WHERE
  type in ('table', 'view')
AND
  name not like 'sqlite?_%' escape '?'

Click to expand...

Dim req As DBRequestManagerRS = CreateRequest
        Dim cmd As DBCommand = CreateCommand("select_schema", Array(nameTable))
        Wait For (req.ExecuteQuery(cmd, 0, Null)) JobDone(j As HttpJob)
        If j.Success Then
            req.HandleJobAsync(j, "req")
            Wait For (req) req_Result(res As DBResult)
            Dim r As Int = 0
            Dim schema As StringBuilder
            schema.Initialize
            For Each row() As Object In res.Rows
                schema.Append(row(r)): r= r +1
            Next
            j.Release

        Else
            Starter.SaveLog($"${nameModule}.Select_Schema job.error: ${j.ErrorMessage}"$)
        End If

Execution finished with errors.
Result: object name reserved for internal use: sqlite_schema
At line 1:
CREATE TABLE sqlite_schema(

Click to expand...

Execution finished with errors.
Result: no such table: sqlite_schema
At line 1:
SELECT * FROM sqlite_schema;

Click to expand...

SQLite creates the schema table upon database creation and modifies its content as SQLite users submit DDL statements for execution. There is no need for users to modify it under normal circumstances, and they bear the risk of database corruption if they do modify it.

Click to expand...