Re: [sqlite] Helping with table definition?

Cesar D. Rodas wrote: Hello, Merry Christmas for every one! I am wondering if someone did a function (the language doesn't care very much) to get the table information and want to share him/her code. Here's some Tcl code that may help. It does more than look at the SQL, but that part may

RE: [sqlite] Helping with table definition?

ing 570 arr2(0) = "-1" 580 arr2(1) = CStr(Err.Number) 590 arr2(2) = Err.Description 600 arr2(3) = CStr(Erl) 610 arr2(4) = strTable 620 arr2(5) = strOmitFields 630 arr2(6) = strAlias 650 GetSQLiteTableInfo2 = arr2 End Function Have a nice Christmas as

Re: [sqlite] Helping with table definition?

Hi, I think you should look at "PRAGMA table_info(table-name);" instead: For each column in the named table, invoke the callback function once with information about that column, including the column name, data type, whether or not the column can be NULL, and the default value for the column.

[sqlite] Helping with table definition?

Hello, Merry Christmas for every one! I am wondering if someone did a function (the language doesn't care very much) to get the table information and want to share him/her code. I know that you can have the SQL definition of a table doing a "select * from sqlite_master where type='table' ", but