singlestore
SingleStore Tested for version 7.6+
Overview Features Supported Objects Download

SingleStore

SingleStore object type support.

The following table shows the database specific support in DbVisualizer for SingleStore organized per database object type.

  • Object Type - show what object types are listed in the Databases tab
  • Actions - show what actions are available for the object type
  • Viewers - show what viewers are available for the object type
Object TypeActionsViewers
Databases
 Create Database Databases, Extended
Catalog
 Export Database[1], Drop Database, Snapshot Database Extended, Info
Tables
 Create Table[1], Import Table Data[1] Tables
Table
 Alter Table[1], Export Table[1], Import Table Data[1], Analyze Table, Create Index, Drop Table, Empty Table, Rename Table, Script: Script Table Data, Columns, DDL[1], Grants, Indexes, Info, Native DDL, Row Count
Columns
   Columns
Column
   Column
Indexes
   Indexes
Index
 Drop Index Index
GlobalTempTables
   Tables
TempTable
 Export Temporary Table[1], Import Temporary Table Data[1], Analyze Temporary Table, Drop Temporary Table, Empty Temporary Table, Script: Script Temporary Table Data, Columns, DDL[1], Grants, Indexes, Info, Native DDL, Row Count
Columns
   Columns
Column
   Column
Indexes
   Indexes
Index
 Drop Index Index
Views
   Views
View
 Export View[1], Drop View, Script: Script View Data, Columns, Grants, Info, Native DDL, Row Count
Columns
   Columns
Column
   Column
Procedures
 Create Procedure Procedures
Procedure
 Export Procedure[1], Drop Procedure, Script: Script Procedure Procedure Editor[1], Info
Functions
 Create Function Functions
Function
 Export Function[1], Drop Function, Script: Script Function Function Editor[1], Info
Aggregates
 Create Aggregate Aggregates
Aggregate
 Drop Aggregate Info
Pipelines
 Start All Pipelines, Stop All Pipelines Pipelines
Pipeline
 Drop Pipeline, Profile Pipeline, Start Pipeline, Stop Pipeline, Test Pipeline Info, Native DDL
DatabaseLinks
 Create Link Links
DatabaseLink
 Drop Link Info
DBA
   DBA
Users
 Create User Users
User
 Drop User, Set Password Grants DDL, Groups, Roles, User
Roles
 Create Role Roles
Role
 Drop Role, Grant to Group Grants DDL, Groups, Users
Groups
 Create Group Groups
Group
 Drop Group, Grant to User Roles, Users
Privileges
   Server Privileges
Processes
   Processes
Process
 Kill Session Process
Status
   Charset, Collation, Session SQL Mode, Status, Variables
TableEngines
   Table Engines
ResourcePools
   Resource Pools
Replications
   Replications
PlanCache
   Plan Cache
Warnings
   Exec Errors, Exec Warnings, Load Errors, Load Warnings
[1] DbVisualizer Pro