Skip to main content
Version: Next

SqlRoutineDef

Resolved routine definition for schema operations (callback bodies resolved to strings).

Index

Properties

optionalbody

body?: string

optionalcomment

comment?: string

optionaldataAccess

dataAccess?: contains-sql | no-sql | reads-sql-data | modifies-sql-data

optionaldefiner

definer?: string

optionaldeterministic

deterministic?: boolean

optionalexpression

expression?: string

optionalignoreSchemaChanges

ignoreSchemaChanges?: RoutineIgnoreField[]

optionallanguage

language?: string

name

name: string

params

optionalreturns

returns?: { nullable?: boolean; runtimeType?: string; type: string }

Type declaration

  • optionalnullable?: boolean
  • optionalruntimeType?: string
  • type: string

optionalschema

schema?: string

optionalsecurity

security?: definer | invoker

type

type: function | procedure