1. Plugins Guide
  2. About Oracle NoSQL Database Visual Studio Code Extension
  3. Managing Tables Using Visual Studio Code Extension

Managing Tables Using Visual Studio Code Extension

Once you connect to your deployment using Oracle NoSQL Database Visual Studio (VS) Code extension, use the TABLE EXPLORER located on the left navigation to:
  • Explore your tables, columns, indexes, primary keys, and shard keys.
  • Create new tables.
  • Drop existing tables.
  • Create Indexes.
  • Drop Indexes.
  • Add columns.
  • Drop Columns.
  • Insert data into table.
  • Execute SELECT SQL queries.

Explore tables, columns, indexes and keys

When you expand an active connection, Oracle NoSQL Database VS Code shows the tables in that deployment.
  • Click the table name to view its columns, indexes, primary key(s), and shard key(s). The column name displays along with its data type.
  • You can refresh the schema or table at any time to re-query your deployment and populate Oracle NoSQL Database with the most up-to-date data.
  • In the TABLE EXPLORER, locate the connection and click the Refresh icon to reload the schema. Alternatively, you can right-click the connection and select Refresh Schema.
  • In the TABLE EXPLORER, locate the table name and click the Refresh icon to reload the table. Alternatively, you can right-click the table name and select Refresh Table.
  • In the TABLE EXPLORER you can verify the data type of a particular column. Locate the particular column and the data type is followed by the column name.
  • Locate the Table Explorer and click the JeCacheSizingTool icon. This is an advanced tool that aides in sizing an On-Premises database. It offers suggested values for cache size, storage size and number of shards based on the inputs.
    • In the JeCacheSizingTool panel, enter the values in bytes for Primary Key Size, Row Size, and Index (this is optional), along with the number of rows. Click Add Table to add values for another table.
    • Click CALCULATE to view the output values. To start a new calculation, click New Calculation.
  • Click the Web Icon in the TABLE EXPLORER to view the list of all the connections present in the plugin. The connections are displayed in the dropdown in the format: Connection Name:Endpoint:Namespace (if specified). Choose the connection from the list and click Connect. The Visual Studio Code plugin connects your project to the Oracle NoSQL Database KVStore and displays its schema in the Table Explorer window.