Introduction
Connect
Create Amazon Redshift Connections
Create ODBC Connections
Create Oracle Connections
Create Snowflake Connections
Create SQL Server Connections
Create SharePoint Connections
Understand Toad Connections
Troubleshoot SQL Server Connections
Understand
Determine the Best Method to Locate Objects
Object Explorer
Filter Databases and Objects
Understand a Table Using the Database Explorer
Search for Objects
Create an Database Diagram to Use as a Query Template
Browse Data in Related Tables
Query
Tutorial: Build a Query Visually
Create Cross-Connection Queries
Reverse Engineer Queries
Build a Subquery
Edit SQL
Editor Shortcut Keys
View Result Sets
Compare Differences in Data
Export Data with One Click Export
Share Excel Linked Queries
Automate
Edit Data in Read-Only Grids
If you cannot edit data because the table does not contain a primary key, you can define a temporary key so that you can edit the data.
Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.
To edit data in a read-only grid
-
Click the red indicator
in the lower left of the data.
-
Accept the defaults to begin editing data or review the following:
Key Columns
Select the columns on which you want to add a temporary key for editing purposes.
Updatable Columns
Select which columns are affected by updates and inserts.
Tip: You can select the drop-down beside 