private SqlStatement ShowTable(ObjectName tableName)
{
var sql = " SELECT \"column\" AS \"name\", " +
" i_sql_type(\"type_desc\", \"size\", \"scale\") AS \"type\", " +
" \"not_null\", " +
" \"index_str\" AS \"index\", " +
" \"default\" " +
" FROM " + InformationSchema.ThisUserTableColumnsViewName + " " +
" WHERE \"schema\" = ? " +
" AND \"table\" = ? " +
"ORDER BY \"seq_no\" ";
var parameters = new[] {
new QueryParameter(PrimitiveTypes.String(), new SqlString(tableName.ParentName)),
new QueryParameter(PrimitiveTypes.String(), new SqlString(tableName.Name))
};
return Show(sql, parameters);
}