Deveel.Data.Sql.Statements.ShowStatement.ShowTable C# (CSharp) Méthode

ShowTable() private méthode

private ShowTable ( ObjectName tableName ) : SqlStatement
tableName ObjectName
Résultat SqlStatement
        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);
        }