sqlite_field_metadata

mIRC SQLite

sqlite_field_metadata
Retrieves meta information about a specific column.
Syntax
$sqlite_field_metadata ( conn [, database ], table, column, htable )
Parameters
conn
The connection identifier.
database
The database name where table exists. Optional, see remarks for details.
table
The table name where column exists.
column
The column to get meta information about.
htable
The hash table to assign results to.
Return Value
1 on success, or $null if there was an error.
Remarks
This identifier fetches meta information about a specific column, and assigns the results to htable.
The hash table will have the following items set:
[pre]
dattype The declared data type, eg. INTEGER
collseq The collation sequence name, eg. BINARY
notnull 1 if NOT NULL constraint exists, otherwise 0
primkey 1 if column is part of PRIMARY KEY, otherwise 0
autoinc 1 if column is AUTOINCREMENT, otherwise 0
[/pre]
The database argument is optional. If omitted all attached databases in conn will be searched for the specified table.