dbDBCraftDocs
Overview
IGetting started
About this guideWhat DBCraft AI Studio isInstallationActivating your licenceConnecting to a databaseA tour of the workspace
IIThe workspace
The menu barThe icon toolbarThe connection chip and container switcherThe docking railThe left panel (cluster drawer)The bottom dockThe status barThe command paletteExtra windows
IIIDevelopment modules
SQL EditorResults grid and data editingGraphsObject Browser and Object ViewerPL/SQL DebuggerUnit Test ManagerReports
IVDBA modules
Schema ToolsVersion HistorySession BrowserDBA Dashboards (Health)Storage BrowserPerformance Profiler and SQL OptimizerIndex AdvisorER Diagram ModelerAutomation and JobsLoad Tester
VTools and utilities
SQL TerminalAI AssistantExport Tables and Import Tables
VIConfiguration and reference
Settings referenceKeyboard shortcutsLicence managementLogging, diagnostics and bug reportsSecurity and data handlingTroubleshootingFile and folder locationsBackend API referenceGlossary
Documentation/Development modules
Chapter 19

Object Browser and Object Viewer

The Object Browser is available as its own module and as the left panel of the Editor, Debugger and Test Manager.

#19.1Navigating

  • Schema dropdown — every schema visible to your account. Defaults to your own.
  • Refresh — re-reads the object list.
  • Search objects… — filters the tree by name as you type; empty type groups disappear.

The tree is Schema → Object type → Object. Each type node shows a count badge. Objects that are INVALID carry a red INVALID badge — invaluable after a bulk recompile.

Supported types, with distinct icons: Table, View, Procedure, Function, Package, Trigger, Sequence, Index, Synonym, Type, Job.

Selecting an object shows a SELECTED footer with its fully-qualified name and type.

#19.2The object context menu

Right-click any object:

ItemAvailable onEffect
Edit & CompileProcedure, Function, Package, TriggerLoads the source into an editable tab. Change it and press Execute to recompile. Compilation errors are marked on the failing line.
View DetailsEverything elseOpens the Object Viewer (§19.5).
Query DataEverything elseOpens a new tab containing SELECT * FROM schema.object;.
Generate DDLAllOpens the Object Viewer on its DDL tab.
Compare…AllOpens the compare dialog (§19.3).
Generate Script ▸Table, ViewGenerates a full SELECT, INSERT, UPDATE or DELETE statement listing every column, with /* value */ placeholders where you must fill in.
Import Data…TableOpens the import wizard (§19.4).
Drop ObjectAll⚠️ Opens a drop tab for the object.

#19.3Comparing two objects

Compare… opens a dialog showing the source object and asking for a target:

  1. Pick the Target Schema.
  2. Pick the Target Object — the list is restricted to objects of the same type, so you cannot compare a table with a package.
  3. Compare DDL.

A Diff tab opens in the editor showing the two definitions side by side with additions and deletions highlighted. The diff view is read-only.

#19.4Importing data into a table

Import Data… on a table opens a small wizard:

  1. Select File — CSV, Excel (.xlsx/.xls) or .fmt.
  2. Click Start Import.

The file’s column headers must exactly match the target table’s column names. The wizard reports the number of rows inserted, or the database error if the import fails.

#19.5The Object Viewer

Opened by View Details or Generate DDL. Three tabs, each loaded on demand and cached until you press Refresh:

TabContents
ColumnsOrdinal, column name, data type, length, and nullable flag.
DataThe first 100 rows of the object. Row numbers are frozen at the left; long values are truncated with the full value in the tooltip.
DDLThe complete CREATE statement from the data dictionary, in a read-only syntax-highlighted editor with a minimap.