This class represents a table in the database. The database is located injSQL.tables and is an object whose keys are table names and values are their respectivejSQLTable classes.

These tables are altered and queried byjSQLQuery objects, but may be interacted with directly if desired.

The name of the table. (string)

An array of the table's column names.

A 2D array of the table's data.

An object whos keys are column names and values are their respective array index.

Renames a column in the table.

• oldname: The name of the column to be changed. (string)
• newname: The new name of the column. (string)

jSQL.tables.Users.renameColumn('Name', 'FullName');jSQL.persist();

Adds a column to a table.

• name: The name of the column to be added. (string)
• newname: The default value for this column. All existing rows will be assigned this value.

jSQL.tables.Users.addColumn('FavoriteColor', 'Green');jSQL.persist();

Adds multiple rows to a table.

• data: A 2D array of data to be added to the table.

var data = [    {Name: "Delux Model", "ProductID": 0},    {Name: "Supreme Model", "ProductID": 1},    {Name: "Super Model", "ProductID": 2},    {Name: "Regular Model", "ProductID": 3},    {Name: "Small Model", "ProductID": 4}];jSQL.tables.Products.loadData(data);jSQL.persist();

Adds a row to a table.

• data: An array of data to be added to the table.

var data = ["Sooper Delux Model", 5];jSQL.tables.Products.insertRow(data);jSQL.persist();