QueryDeleteColumn

Deletes a column within a query object.

Method Signature

QueryDeleteColumn(query=[query], column=[string])

Arguments

Argument	Type	Required	Description	Default
query	query	true	The query object to which the column should be deleted.
column	string	true	The name of the column to delete.

Examples

Deletes a column from the query

Builds a simple query and removes the 'id' column.

Run Example

news = queryNew( "id,title", "integer,varchar", [ 
	{
		"id" : 1,
		"title" : "Dewey defeats Truman"
	},
	{
		"id" : 2,
		"title" : "Man walks on Moon"
	}
] );
queryDeleteColumn( news, "id" );
writeOutput( JSONSerialize( news ) );

Result: {"COLUMNS":["TITLE"],"DATA":[["Dewey defeats Truman"],["Man walks on Moon"]]}

Additional Examples

Run Example

qry1 = queryNew( "a,b,c", "varchar,varchar,varchar", [ 
	[
		"a1",
		"b1",
		"c1"
	],
	[
		"a2",
		"b2",
		"c2"
	],
	[
		"a3",
		"b3",
		"c3"
	]
] );
queryDeleteColumn( qry1, "c" );
writeOutput( qry1.COLUMNLIST );
qry2 = queryNew( "x,y,z", "varchar,varchar,varchar", [
	[
		"x1",
		"y1",
		"z1"
	],
	[
		"x2",
		"y2",
		"z2"
	],
	[
		"x3",
		"y3",
		"z3"
	]
] );
bx:loop query="qry2" {
	queryDeleteColumn( qry2, listFirst( qry2.COLUMNLIST ) );
}
writeDump( qry2.COLUMNLIST );

Related

• QueryRecordCount

• QueryColumnList

• QueryRowSwap

• QuerySort

• QueryEach

• QueryKeyExists

• QueryColumnCount

• QueryReduce

• QueryCurrentRow

• QueryColumnData

• QueryRowData

• QueryFilter

• QueryAddRow

• QueryNew

• QueryReverse

• QueryPrepend

• QueryColumnExists

• QueryAddColumn

• QueryGetCell

• QueryGetResult

• QueryMap

• QueryEvery

• QueryRecordCount

• QuerySome

• QuerySetCell

• QueryInsertAt

• QueryClear

• QuerySetRow

• QueryColumnArray

• QueryDeleteRow

• QueryAppend

• QuerySlice

• QueryRegisterFunction