SQLite Metadata Support

[RohitM-IN]

So please tell me what is possible and what is not

• Tables
• Columns
• PrimaryKeys
• ForeignKeys
• UniqueKeys
• DefaultConstraints
• CheckConstraints
• Indices
• UserDataTypes
• UserTableTypes

this is what i know tables is easy

SELECT
    name AS table_name,
    type AS table_type,
    sql AS create_statement -- no need for this i know as we cannot use this to make other data 
FROM
    sqlite_master
WHERE
    type = 'table'
ORDER BY
    name;

I dont think there is any thing more than that that offers to expose like client-server databases offer

but for just syncing data its possible ref: #21

[RohitM-IN]

Also I think we can implement something like MSSQL to SQLite Metadata Sync as we have all the data we need to make a sql query right @Psychac but the other way round is not possible