Use the fetch function with the connection object to import data from a database in one step.

In prior releases, you wrote multiple lines of code to create the cursor object, import data, and find the names of the database columns. For example:

curs = exec(conn,sqlquery);
curs = fetch(curs);
results = curs.Data;
columnlist = columnnames(curs);
close(curs)

Now you can import data in one step using the fetch function, and then access properties of the output table.

results = fetch(conn,sqlquery);
results.Properties.VariableNames

If you return imported data as a table, access details about the variables in the table by using the table properties or a function such as summary.

There is no replacement functionality for the columnnames function.