Discussion forums for open issues and questions concerning database tools, data access components and developer tools from Devart
https://forums.devart.com/
Code: Select all
static void Main(string[] args)
{
SQLiteConnection conn = new SQLiteConnection("your connection string");
DataTable dt = GetColumns(conn);
}
static DataTable GetColumns(SQLiteConnection conn)
{
conn.Open();
var dt = conn.GetSchema("Columns");
conn.Close();
dt.Columns["Catalog"].ColumnName = "TABLE_CATALOG";
dt.Columns["Schema"].ColumnName = "TABLE_SCHEMA";
dt.Columns["Table"].ColumnName = "TABLE_NAME";
dt.Columns["Name"].ColumnName = "COLUMN_NAME";
dt.Columns["Position"].ColumnName = "ORDINAL_POSITION";
dt.Columns["HasDefaultValue"].ColumnName = "COLUMN_HASDEFAULT";
dt.Columns["DefaultValue"].ColumnName = "COLUMN_DEFAULT";
dt.Columns["Nullable"].ColumnName = "IS_NULLABLE";
dt.Columns["TypeName"].ColumnName = "DATA_TYPE";
dt.Columns["CharacterMaximumLength"].ColumnName = "CHARACTER_MAXIMUM_LENGTH";
dt.Columns["NumericPrecision"].ColumnName = "NUMERIC_PRECISION";
dt.Columns["NumericScale"].ColumnName = "NUMERIC_SCALE";
dt.Columns["IsUnique"].ColumnName = "UNIQUE";
dt.Columns["PrimaryKey"].ColumnName = "PRIMARY_KEY";
return dt;
}