HTML5 SQLite getting column names, Promises

HTML5 SQLite getting column names, Promises

// jQuery Required
// Creating / Opening DB
var db = window.openDatabase("techm", "1.0", "TechM Employees", 100000)

function createTable(table, fields,cb) {
	db.transaction(function (tx) {
		tx.executeSql('create table ' + table + fields, [], function () {
			return cb("Table Created : " + table)
		}, function () {
			return cb("SQL Error")
		});

	})
}
createTable("employee", "(id INTEGER,name TEXT)",function(msg){console.log(msg);})

// Get columns function
function getColumns(table,cb) {
	var dfd = $.Deferred();
	var x;
	db.transaction(function (tx) {
		tx.executeSql('SELECT name, sql FROM sqlite_master WHERE type="table" AND name = "' + table + '"', [], function (tx, results) {
			var columnParts = results.rows.item(0).sql.replace(/^[^\(]+\(([^\)]+)\)/g, '$1').split(',');
			var columnNames = [];
			for (i in columnParts) {
				if (typeof columnParts[i] === 'string')
					columnNames.push(columnParts[i].split(" ")[0]);
			}
			dfd.resolve(columnNames);

		}, function () {
			dfd.resolve("sQL Error");
		});

	})
	return dfd.done(function (value) {
		 cb(value);
	}) ;
}


getColumns("employee",function(columns){console.log(columns)});