gosmo

package module

Go to main page

Versions in this module

v0

v0.0.13

Sep 15, 2026

Changes in this version

+ var ProbedSecurablePermissions = []string

+ func DatabaseSecurableKey(kind DatabaseSecurableKind, schema, name string) string

+ type Assembly struct

+ AssemblyID int

+ ClrName string

+ CreateDate time.Time

+ IsUserDefined bool

+ IsVisible bool

+ ModifyDate time.Time

+ Name string

+ Owner string

+ PermissionSet AssemblyPermissionSet

+ func (a *Assembly) Database() *Database

+ func (a *Assembly) Drop() error

+ func (a *Assembly) DropContext(ctx context.Context) error

+ func (a *Assembly) FileContent(fileID int) ([]byte, error)

+ func (a *Assembly) FileContentContext(ctx context.Context, fileID int) ([]byte, error)

+ func (a *Assembly) Files() ([]*AssemblyFile, error)

+ func (a *Assembly) FilesContext(ctx context.Context) ([]*AssemblyFile, error)

+ func (a *Assembly) Modules() ([]*AssemblyModule, error)

+ func (a *Assembly) ModulesContext(ctx context.Context) ([]*AssemblyModule, error)

+ type AssemblyFile struct

+ ContentLength int64

+ FileID int

+ Name string

+ type AssemblyModule struct

+ AssemblyClass string

+ AssemblyMethod string

+ Name string

+ ObjectID int

+ Schema string

+ Type string

+ func (m *AssemblyModule) FullName() string

+ type AssemblyPermissionSet string

+ const AssemblyExternalAccess

+ const AssemblySafe

+ const AssemblyUnsafe

type AuthMethod

+ func (m AuthMethod) String() string

+ type ClrType struct

+ Assembly string

+ AssemblyClass string

+ IsNullable bool

+ MaxLength int

+ Name string

+ Precision int

+ Scale int

+ Schema string

+ UserTypeID int

+ func (t *ClrType) Database() *Database

+ func (t *ClrType) Drop() error

+ func (t *ClrType) DropContext(ctx context.Context) error

+ func (t *ClrType) FullName() string

type ConnectionOptions

+ DeviceCodePrompt func(ctx context.Context, m DeviceCodeMessage) error

+ EntraCache *EntraCache

+ ExtraParams url.Values

+ func (o ConnectionOptions) ConnectionString(maskSecrets bool) (string, error)

+ type CreateDatabaseSnapshotRequest struct

+ Files []SnapshotFileSpec

+ Name string

+ SourceDatabase string

type Database

+ func (d *Database) Assemblies() ([]*Assembly, error)

+ func (d *Database) AssembliesContext(ctx context.Context) ([]*Assembly, error)

+ func (d *Database) AssemblyByName(name string) (*Assembly, error)

+ func (d *Database) AssemblyByNameContext(ctx context.Context, name string) (*Assembly, error)

+ func (d *Database) AssemblySeq(ctx context.Context) iter.Seq2[*Assembly, error]

+ func (d *Database) ClrTypeByName(schema, name string) (*ClrType, error)

+ func (d *Database) ClrTypeByNameContext(ctx context.Context, schema, name string) (*ClrType, error)

+ func (d *Database) ClrTypeSeq(ctx context.Context) iter.Seq2[*ClrType, error]

+ func (d *Database) ClrTypes() ([]*ClrType, error)

+ func (d *Database) ClrTypesContext(ctx context.Context) ([]*ClrType, error)

+ func (d *Database) DefaultByName(schema, name string) (*Default, error)

+ func (d *Database) DefaultByNameContext(ctx context.Context, schema, name string) (*Default, error)

+ func (d *Database) DefaultSeq(ctx context.Context) iter.Seq2[*Default, error]

+ func (d *Database) Defaults() ([]*Default, error)

+ func (d *Database) DefaultsContext(ctx context.Context) ([]*Default, error)

+ func (d *Database) DiskUsage() (DiskUsage, error)

+ func (d *Database) DiskUsageContext(ctx context.Context) (DiskUsage, error)

+ func (d *Database) DropAssembly(name string) error

+ func (d *Database) DropAssemblyContext(ctx context.Context, name string) error

+ func (d *Database) DropDefault(schema, name string) error

+ func (d *Database) DropDefaultContext(ctx context.Context, schema, name string) error

+ func (d *Database) DropExternalDataSource(name string) error

+ func (d *Database) DropExternalDataSourceContext(ctx context.Context, name string) error

+ func (d *Database) DropExternalFileFormat(name string) error

+ func (d *Database) DropExternalFileFormatContext(ctx context.Context, name string) error

+ func (d *Database) DropExternalLibrary(name string) error

+ func (d *Database) DropExternalLibraryContext(ctx context.Context, name string) error

+ func (d *Database) DropPlanGuide(name string) error

+ func (d *Database) DropPlanGuideContext(ctx context.Context, name string) error

+ func (d *Database) DropRule(schema, name string) error

+ func (d *Database) DropRuleContext(ctx context.Context, schema, name string) error

+ func (d *Database) DropType(schema, name string) error

+ func (d *Database) DropTypeContext(ctx context.Context, schema, name string) error

+ func (d *Database) DropXmlSchemaCollection(schema, name string) error

+ func (d *Database) DropXmlSchemaCollectionContext(ctx context.Context, schema, name string) error

+ func (d *Database) ExternalDataSourceByName(name string) (*ExternalDataSource, error)

+ func (d *Database) ExternalDataSourceByNameContext(ctx context.Context, name string) (*ExternalDataSource, error)

+ func (d *Database) ExternalDataSourceSeq(ctx context.Context) iter.Seq2[*ExternalDataSource, error]

+ func (d *Database) ExternalDataSources() ([]*ExternalDataSource, error)

+ func (d *Database) ExternalDataSourcesContext(ctx context.Context) ([]*ExternalDataSource, error)

+ func (d *Database) ExternalFileFormatByName(name string) (*ExternalFileFormat, error)

+ func (d *Database) ExternalFileFormatByNameContext(ctx context.Context, name string) (*ExternalFileFormat, error)

+ func (d *Database) ExternalFileFormatSeq(ctx context.Context) iter.Seq2[*ExternalFileFormat, error]

+ func (d *Database) ExternalFileFormats() ([]*ExternalFileFormat, error)

+ func (d *Database) ExternalFileFormatsContext(ctx context.Context) ([]*ExternalFileFormat, error)

+ func (d *Database) ExternalLibraries() ([]*ExternalLibrary, error)

+ func (d *Database) ExternalLibrariesContext(ctx context.Context) ([]*ExternalLibrary, error)

+ func (d *Database) ExternalLibraryByName(name string) (*ExternalLibrary, error)

+ func (d *Database) ExternalLibraryByNameContext(ctx context.Context, name string) (*ExternalLibrary, error)

+ func (d *Database) ExternalLibrarySeq(ctx context.Context) iter.Seq2[*ExternalLibrary, error]

+ func (d *Database) IsSnapshot() bool

+ func (d *Database) LatestResourceStats() (*DatabaseResourceStat, error)

+ func (d *Database) LatestResourceStatsContext(ctx context.Context) (*DatabaseResourceStat, error)

+ func (d *Database) PlanGuide(name string) *PlanGuide

+ func (d *Database) PlanGuideByName(name string) (*PlanGuide, error)

+ func (d *Database) PlanGuideByNameContext(ctx context.Context, name string) (*PlanGuide, error)

+ func (d *Database) PlanGuideSeq(ctx context.Context) iter.Seq2[*PlanGuide, error]

+ func (d *Database) PlanGuides() ([]*PlanGuide, error)

+ func (d *Database) PlanGuidesContext(ctx context.Context) ([]*PlanGuide, error)

+ func (d *Database) RenameUserDefinedDataType(schema, oldName, newName string) error

+ func (d *Database) RenameUserDefinedDataTypeContext(ctx context.Context, schema, oldName, newName string) error

+ func (d *Database) ResourceGovernance() (*UserDBResourceGovernance, error)

+ func (d *Database) ResourceGovernanceContext(ctx context.Context) (*UserDBResourceGovernance, error)

+ func (d *Database) ResourceStats(max int) ([]*DatabaseResourceStat, error)

+ func (d *Database) ResourceStatsContext(ctx context.Context, max int) ([]*DatabaseResourceStat, error)

+ func (d *Database) RuleByName(schema, name string) (*Rule, error)

+ func (d *Database) RuleByNameContext(ctx context.Context, schema, name string) (*Rule, error)

+ func (d *Database) RuleSeq(ctx context.Context) iter.Seq2[*Rule, error]

+ func (d *Database) Rules() ([]*Rule, error)

+ func (d *Database) RulesContext(ctx context.Context) ([]*Rule, error)

+ func (d *Database) SourceDatabaseID() int

+ func (d *Database) SystemDataTypeSeq(ctx context.Context) iter.Seq2[*SystemDataType, error]

+ func (d *Database) SystemDataTypes() ([]*SystemDataType, error)

+ func (d *Database) SystemDataTypesContext(ctx context.Context) ([]*SystemDataType, error)

+ func (d *Database) TableKindsPresent() (TableKindPresence, error)

+ func (d *Database) TableKindsPresentContext(ctx context.Context) (TableKindPresence, error)

+ func (d *Database) TablesOfKind(kind TableKind) ([]*Table, error)

+ func (d *Database) TablesOfKindContext(ctx context.Context, kind TableKind) ([]*Table, error)

+ func (d *Database) TablesOfKindFiltered(kind TableKind, filter ObjectFilter) ([]*Table, error)

+ func (d *Database) TablesOfKindFilteredContext(ctx context.Context, kind TableKind, filter ObjectFilter) ([]*Table, error)

+ func (d *Database) TransferType(targetSchema, schema, name string) error

+ func (d *Database) TransferTypeContext(ctx context.Context, targetSchema, schema, name string) error

+ func (d *Database) TransferXmlSchemaCollection(targetSchema, schema, name string) error

+ func (d *Database) TransferXmlSchemaCollectionContext(ctx context.Context, targetSchema, schema, name string) error

+ func (d *Database) UserDefinedDataTypeByName(schema, name string) (*UserDefinedDataType, error)

+ func (d *Database) UserDefinedDataTypeByNameContext(ctx context.Context, schema, name string) (*UserDefinedDataType, error)

+ func (d *Database) UserDefinedDataTypeSeq(ctx context.Context) iter.Seq2[*UserDefinedDataType, error]

+ func (d *Database) UserDefinedDataTypes() ([]*UserDefinedDataType, error)

+ func (d *Database) UserDefinedDataTypesContext(ctx context.Context) ([]*UserDefinedDataType, error)

+ func (d *Database) UserDefinedTableTypeByName(schema, name string) (*UserDefinedTableType, error)

+ func (d *Database) UserDefinedTableTypeByNameContext(ctx context.Context, schema, name string) (*UserDefinedTableType, error)

+ func (d *Database) UserDefinedTableTypeSeq(ctx context.Context) iter.Seq2[*UserDefinedTableType, error]

+ func (d *Database) UserDefinedTableTypes() ([]*UserDefinedTableType, error)

+ func (d *Database) UserDefinedTableTypesContext(ctx context.Context) ([]*UserDefinedTableType, error)

+ func (d *Database) XmlSchemaCollectionByName(schema, name string) (*XmlSchemaCollection, error)

+ func (d *Database) XmlSchemaCollectionByNameContext(ctx context.Context, schema, name string) (*XmlSchemaCollection, error)

+ func (d *Database) XmlSchemaCollectionSeq(ctx context.Context) iter.Seq2[*XmlSchemaCollection, error]

+ func (d *Database) XmlSchemaCollections() ([]*XmlSchemaCollection, error)

+ func (d *Database) XmlSchemaCollectionsContext(ctx context.Context) ([]*XmlSchemaCollection, error)

type DatabaseCapabilities

+ SecurablePermissions map[string]map[string]CapabilityState

+ func (c *DatabaseCapabilities) HasOnSecurable(kind DatabaseSecurableKind, schema, name, perm string) bool

+ func (c *DatabaseCapabilities) PermitsOnSecurable(kind DatabaseSecurableKind, schema, name, perm string) bool

+ func (c *DatabaseCapabilities) SecurablePermission(kind DatabaseSecurableKind, schema, name, perm string) CapabilityState

+ type DatabaseResourceStat struct

+ AllocatedStorageMB int64

+ AvgCPUPercent float64

+ AvgDataIOPercent float64

+ AvgInstanceCPUPercent float64

+ AvgInstanceMemoryPercent float64

+ AvgLogWritePercent float64

+ AvgLoginRatePercent float64

+ AvgMemoryUsagePercent float64

+ CPULimit float64

+ DTULimit int

+ EndTime time.Time

+ MaxSessionPercent float64

+ MaxWorkerPercent float64

+ ReplicaRole int

+ UsedStorageMB int64

+ XTPStoragePercent float64

+ type DatabaseSecurableKind string

+ const DatabaseSecurableAssembly

+ const DatabaseSecurableType

+ const DatabaseSecurableXmlSchemaCollection

+ type DatabaseSnapshot struct

+ CreateDate time.Time

+ DatabaseID int

+ Name string

+ SourceDatabase string

+ SourceDatabaseID int

+ State string

+ func (s *DatabaseSnapshot) Database() *Database

+ func (s *DatabaseSnapshot) Drop() error

+ func (s *DatabaseSnapshot) DropContext(ctx context.Context) error

+ func (s *DatabaseSnapshot) Restore() error

+ func (s *DatabaseSnapshot) RestoreContext(ctx context.Context) error

+ func (s *DatabaseSnapshot) Server() *Server

+ type Default struct

+ CreateDate time.Time

+ Definition string

+ ModifyDate time.Time

+ Name string

+ ObjectID int

+ Schema string

+ func (df *Default) Database() *Database

+ func (df *Default) Drop() error

+ func (df *Default) DropContext(ctx context.Context) error

+ func (df *Default) FullName() string

+ type DeviceCodeMessage struct

+ Message string

+ UserCode string

+ VerificationURL string

+ type DiskUsage struct

+ DataFilesMB float64

+ DataMB float64

+ IndexMB float64

+ LogFilesMB float64

+ LogUnusedMB float64

+ LogUsedMB float64

+ UnallocatedMB float64

+ UnusedMB float64

+ type EntraCache struct

+ func NewEntraCache() *EntraCache

+ func (c *EntraCache) Clear()

+ func (c *EntraCache) Warm(ctx context.Context, opts ConnectionOptions) error

+ type ExternalDataSource struct

+ ConnectionOptions string

+ Credential string

+ DataSourceID int

+ DatabaseName string

+ Location string

+ Name string

+ PushdownEnabled bool

+ ResourceManagerLocation string

+ ShardMapName string

+ Type string

+ func (s *ExternalDataSource) Database() *Database

+ func (s *ExternalDataSource) Drop() error

+ func (s *ExternalDataSource) DropContext(ctx context.Context) error

+ type ExternalFileFormat struct

+ DataCompression string

+ DateFormat string

+ Encoding string

+ FieldTerminator string

+ FileFormatID int

+ FirstRow int

+ FormatType string

+ Name string

+ ParserVersion string

+ RowTerminator string

+ SerDeMethod string

+ StringDelimiter string

+ UseTypeDefault bool

+ func (f *ExternalFileFormat) Database() *Database

+ func (f *ExternalFileFormat) Drop() error

+ func (f *ExternalFileFormat) DropContext(ctx context.Context) error

+ type ExternalLibrary struct

+ Language string

+ LibraryID int

+ Name string

+ Owner string

+ Scope string

+ func (l *ExternalLibrary) Database() *Database

+ func (l *ExternalLibrary) Drop() error

+ func (l *ExternalLibrary) DropContext(ctx context.Context) error

+ type ExtraParamError struct

+ Key string

+ Reserved bool

+ func (e *ExtraParamError) Error() string

+ type PlanGuide struct

+ CreateDate time.Time

+ Hints string

+ IsDisabled bool

+ ModifyDate time.Time

+ Name string

+ Parameters string

+ PlanGuideID int

+ QueryText string

+ Scope PlanGuideScope

+ ScopeBatch string

+ ScopeName string

+ ScopeObject string

+ ScopeSchema string

+ func (g *PlanGuide) Database() *Database

+ func (g *PlanGuide) Disable() error

+ func (g *PlanGuide) DisableContext(ctx context.Context) error

+ func (g *PlanGuide) Drop() error

+ func (g *PlanGuide) DropContext(ctx context.Context) error

+ func (g *PlanGuide) Enable() error

+ func (g *PlanGuide) EnableContext(ctx context.Context) error

+ type PlanGuideScope string

+ const PlanGuideScopeObject

+ const PlanGuideScopeSQL

+ const PlanGuideScopeTemplate

+ type Rule struct

+ CreateDate time.Time

+ Definition string

+ ModifyDate time.Time

+ Name string

+ ObjectID int

+ Schema string

+ func (r *Rule) Database() *Database

+ func (r *Rule) Drop() error

+ func (r *Rule) DropContext(ctx context.Context) error

+ func (r *Rule) FullName() string

type Scripter

+ func (sc *Scripter) ScriptAssembly(name string) (string, error)

+ func (sc *Scripter) ScriptAssemblyContext(ctx context.Context, name string) (string, error)

+ func (sc *Scripter) ScriptClrType(schema, name string) (string, error)

+ func (sc *Scripter) ScriptClrTypeContext(ctx context.Context, schema, name string) (string, error)

+ func (sc *Scripter) ScriptDefault(schema, name string) (string, error)

+ func (sc *Scripter) ScriptDefaultContext(ctx context.Context, schema, name string) (string, error)

+ func (sc *Scripter) ScriptExternalDataSource(name string) (string, error)

+ func (sc *Scripter) ScriptExternalDataSourceContext(ctx context.Context, name string) (string, error)

+ func (sc *Scripter) ScriptExternalFileFormat(name string) (string, error)

+ func (sc *Scripter) ScriptExternalFileFormatContext(ctx context.Context, name string) (string, error)

+ func (sc *Scripter) ScriptExternalLibrary(name string) (string, error)

+ func (sc *Scripter) ScriptExternalLibraryContext(ctx context.Context, name string) (string, error)

+ func (sc *Scripter) ScriptPlanGuide(name string) (string, error)

+ func (sc *Scripter) ScriptPlanGuideContext(ctx context.Context, name string) (string, error)

+ func (sc *Scripter) ScriptRule(schema, name string) (string, error)

+ func (sc *Scripter) ScriptRuleContext(ctx context.Context, schema, name string) (string, error)

+ func (sc *Scripter) ScriptUserDefinedDataType(schema, name string) (string, error)

+ func (sc *Scripter) ScriptUserDefinedDataTypeContext(ctx context.Context, schema, name string) (string, error)

+ func (sc *Scripter) ScriptUserDefinedTableType(schema, name string) (string, error)

+ func (sc *Scripter) ScriptUserDefinedTableTypeContext(ctx context.Context, schema, name string) (string, error)

+ func (sc *Scripter) ScriptXmlSchemaCollection(schema, name string) (string, error)

+ func (sc *Scripter) ScriptXmlSchemaCollectionContext(ctx context.Context, schema, name string) (string, error)

type Server

+ func (s *Server) CreateDatabaseSnapshot(req CreateDatabaseSnapshotRequest) (*DatabaseSnapshot, error)

+ func (s *Server) CreateDatabaseSnapshotContext(ctx context.Context, req CreateDatabaseSnapshotRequest) (*DatabaseSnapshot, error)

+ func (s *Server) DatabaseSnapshot(name string) *DatabaseSnapshot

+ func (s *Server) DatabaseSnapshotByName(name string) (*DatabaseSnapshot, error)

+ func (s *Server) DatabaseSnapshotByNameContext(ctx context.Context, name string) (*DatabaseSnapshot, error)

+ func (s *Server) DatabaseSnapshotSeq(ctx context.Context) iter.Seq2[*DatabaseSnapshot, error]

+ func (s *Server) DatabaseSnapshots() ([]*DatabaseSnapshot, error)

+ func (s *Server) DatabaseSnapshotsContext(ctx context.Context) ([]*DatabaseSnapshot, error)

+ func (s *Server) RestoreFromSnapshot(database, snapshot string) error

+ func (s *Server) RestoreFromSnapshotContext(ctx context.Context, database, snapshot string) error

+ func (s *Server) SnapshotFileDefaults(source, snapshotName string) ([]SnapshotFileSpec, error)

+ func (s *Server) SnapshotFileDefaultsContext(ctx context.Context, source, snapshotName string) ([]SnapshotFileSpec, error)

+ func (s *Server) SnapshotsOf(database string) ([]*DatabaseSnapshot, error)

+ func (s *Server) SnapshotsOfContext(ctx context.Context, database string) ([]*DatabaseSnapshot, error)

+ func (s *Server) UserDBResourceGovernance() ([]*UserDBResourceGovernance, error)

+ func (s *Server) UserDBResourceGovernanceContext(ctx context.Context) ([]*UserDBResourceGovernance, error)

+ func (s *Server) UserDBResourceGovernanceSeq(ctx context.Context) iter.Seq2[*UserDBResourceGovernance, error]

+ type SnapshotFileSpec struct

+ FileName string

+ LogicalName string

+ type SystemDataType struct

+ IsNullable bool

+ MaxLength int

+ Name string

+ Precision int

+ Scale int

+ SystemType int

type Table

+ IsEdge bool

+ IsExternal bool

+ IsFileTable bool

+ IsNode bool

+ IsSystem bool

+ type TableKind int

+ const TableKindExternal

+ const TableKindFileTable

+ const TableKindGraph

+ const TableKindSystem

+ const TableKindUser

+ func (k TableKind) String() string

+ type TableKindPresence struct

+ External bool

+ FileTable bool

+ Graph bool

+ System bool

+ type UserDBResourceGovernance struct

+ BufferPoolExtensionGB int

+ CPULimit int

+ CapCPU int

+ CheckpointRateIO int

+ CheckpointRateMBps int

+ DBFileGrowthMB int64

+ DTULimit int

+ DataDirectoryQuotaMB int

+ DataDirectoryUsageMB int

+ DatabaseID int

+ DatabaseName string

+ DefaultDBMaxSizeMB int64

+ ExternalXStoreIOPS int

+ GovernBackgroundIO bool

+ GovernDBMemoryInPool bool

+ InitialDBFileSizeMB int64

+ InstanceCapCPU int

+ InstanceMaxLogRate int64

+ InstanceMaxWorkerThreads int

+ LastUpdatedUTC time.Time

+ LocalIOPS int

+ LogSizeMB int64

+ LogicalDatabaseGUID string

+ ManagedXStoreIOPS int

+ MaxCPU int

+ MaxDBMaxSizeMB int64

+ MaxDBMemory int

+ MaxDOP int

+ MaxMemory int

+ MaxMemoryGrant int

+ MaxSessions int

+ MaxTransactionSize int64

+ MinCPU int

+ MinCores int

+ MinDBMaxSizeMB int64

+ MinMemory int

+ PFSIOPS int

+ PhysicalDatabaseGUID string

+ PoolMaxIO int

+ PoolMaxLogRate int64

+ PrimaryGroupID int

+ PrimaryGroupMaxCPU float64

+ PrimaryGroupMaxIO int

+ PrimaryGroupMaxOutbound int

+ PrimaryGroupMaxWorkers int

+ PrimaryGroupMinCPU float64

+ PrimaryGroupMinIO int

+ PrimaryLogCommitFee int

+ PrimaryMaxLogRate int64

+ PrimaryMinLogRate int64

+ PrimaryPoolMaxOutbound int

+ PrimaryPoolMaxWorkers int

+ ReplicaRole int

+ ReplicaType int

+ SLOName string

+ ServerName string

+ TypeExternalXStoreIOPS int

+ TypeLocalIOPS int

+ TypeManagedXStoreIOPS int

+ TypePFSIOPS int

+ TypeRBIODataIOPS int

+ type UserDefinedDataType struct

+ BaseType string

+ Collation string

+ Default string

+ IsNullable bool

+ MaxLength int

+ Name string

+ Precision int

+ Rule string

+ Scale int

+ Schema string

+ UserTypeID int

+ func (t *UserDefinedDataType) Database() *Database

+ func (t *UserDefinedDataType) Drop() error

+ func (t *UserDefinedDataType) DropContext(ctx context.Context) error

+ func (t *UserDefinedDataType) FullName() string

+ type UserDefinedTableType struct

+ IsMemoryOptimized bool

+ Name string

+ Schema string

+ TypeTableObjectID int

+ UserTypeID int

+ func (t *UserDefinedTableType) Columns() ([]*Column, error)

+ func (t *UserDefinedTableType) ColumnsContext(ctx context.Context) ([]*Column, error)

+ func (t *UserDefinedTableType) Database() *Database

+ func (t *UserDefinedTableType) Drop() error

+ func (t *UserDefinedTableType) DropContext(ctx context.Context) error

+ func (t *UserDefinedTableType) FullName() string

+ type XmlSchemaCollection struct

+ CollectionID int

+ CreateDate time.Time

+ ModifyDate time.Time

+ Name string

+ Schema string

+ func (c *XmlSchemaCollection) Database() *Database

+ func (c *XmlSchemaCollection) Definition() (string, error)

+ func (c *XmlSchemaCollection) DefinitionContext(ctx context.Context) (string, error)

+ func (c *XmlSchemaCollection) Drop() error

+ func (c *XmlSchemaCollection) DropContext(ctx context.Context) error

+ func (c *XmlSchemaCollection) FullName() string

v0.0.12

Sep 8, 2026

Changes in this version

+ const FileStreamFileGroup

+ const MemoryOptimizedFileGroup

+ const RowsFileGroup

+ var ProbedAvailabilityGroupPermissions = []string

+ var ProbedPrincipalPermissions = []string

+ var ProbedServerSecurablePermissions = []string

+ func IsBackupURL(device string) bool

+ func ServerSecurableKey(kind ServerSecurableKind, name string) string

type BackupOptions

+ Credential string

type BackupTarget

+ func URLTarget(url string) BackupTarget

type Capabilities

+ AvailabilityGroupPermissions map[string]map[string]CapabilityState

+ ExplicitServerPermissions map[string]map[string]CapabilityState

+ func (c *Capabilities) AvailabilityGroupPermission(group, name string) CapabilityState

+ func (c *Capabilities) DeniedOnEndpoint(name, permission string) bool

+ func (c *Capabilities) DeniedOnLogin(name, permission string) bool

+ func (c *Capabilities) DeniedOnServerRole(name, permission string) bool

+ func (c *Capabilities) DeniedOnServerSecurable(kind ServerSecurableKind, name, permission string) bool

+ func (c *Capabilities) HasOnAvailabilityGroup(group, name string) bool

+ func (c *Capabilities) PermitsOnAvailabilityGroup(group, name string) bool

type Database

+ func (d *Database) CreateDatabaseAuditSpecification(spec DatabaseAuditSpecificationSpec) (*DatabaseAuditSpecification, error)

+ func (d *Database) CreateDatabaseAuditSpecificationContext(ctx context.Context, spec DatabaseAuditSpecificationSpec) (*DatabaseAuditSpecification, error)

+ func (d *Database) CreateDatabaseScopedCredential(spec DatabaseScopedCredentialSpec) (*DatabaseScopedCredential, error)

+ func (d *Database) CreateDatabaseScopedCredentialContext(ctx context.Context, spec DatabaseScopedCredentialSpec) (*DatabaseScopedCredential, error)

+ func (d *Database) DatabaseAuditSpecification(name string) *DatabaseAuditSpecification

+ func (d *Database) DatabaseAuditSpecificationByName(name string) (*DatabaseAuditSpecification, error)

+ func (d *Database) DatabaseAuditSpecificationByNameContext(ctx context.Context, name string) (*DatabaseAuditSpecification, error)

+ func (d *Database) DatabaseAuditSpecifications() ([]*DatabaseAuditSpecification, error)

+ func (d *Database) DatabaseAuditSpecificationsContext(ctx context.Context) ([]*DatabaseAuditSpecification, error)

+ func (d *Database) DatabaseScopedCredential(name string) *DatabaseScopedCredential

+ func (d *Database) DatabaseScopedCredentialByName(name string) (*DatabaseScopedCredential, error)

+ func (d *Database) DatabaseScopedCredentialByNameContext(ctx context.Context, name string) (*DatabaseScopedCredential, error)

+ func (d *Database) DatabaseScopedCredentialSeq(ctx context.Context) iter.Seq2[*DatabaseScopedCredential, error]

+ func (d *Database) DatabaseScopedCredentials() ([]*DatabaseScopedCredential, error)

+ func (d *Database) DatabaseScopedCredentialsContext(ctx context.Context) ([]*DatabaseScopedCredential, error)

+ func (d *Database) DatabaseTrigger(name string) *DatabaseTrigger

+ func (d *Database) DatabaseTriggerByName(name string) (*DatabaseTrigger, error)

+ func (d *Database) DatabaseTriggerByNameContext(ctx context.Context, name string) (*DatabaseTrigger, error)

+ func (d *Database) DatabaseTriggerSeq(ctx context.Context) iter.Seq2[*DatabaseTrigger, error]

+ func (d *Database) DatabaseTriggers() ([]*DatabaseTrigger, error)

+ func (d *Database) DatabaseTriggersContext(ctx context.Context) ([]*DatabaseTrigger, error)

+ func (d *Database) ObjectTriggers(schema, name string) ([]*Trigger, error)

+ func (d *Database) ObjectTriggersContext(ctx context.Context, schema, name string) ([]*Trigger, error)

+ type DatabaseAuditAction struct

+ ActionName string

+ AuditedResult string

+ ClassDesc string

+ ObjectName string

+ Principal string

+ SchemaName string

+ func (a DatabaseAuditAction) FullName() string

+ type DatabaseAuditSpecification struct

+ ActionGroups []string

+ Actions []DatabaseAuditAction

+ AuditGUID string

+ AuditName string

+ CreateDate time.Time

+ IsEnabled bool

+ ModifyDate time.Time

+ Name string

+ SpecificationID int

+ func (spec *DatabaseAuditSpecification) AddActions(groups []string, actions []DatabaseAuditAction) error

+ func (spec *DatabaseAuditSpecification) AddActionsContext(ctx context.Context, groups []string, actions []DatabaseAuditAction) error

+ func (spec *DatabaseAuditSpecification) Database() *Database

+ func (spec *DatabaseAuditSpecification) Drop() error

+ func (spec *DatabaseAuditSpecification) DropActions(groups []string, actions []DatabaseAuditAction) error

+ func (spec *DatabaseAuditSpecification) DropActionsContext(ctx context.Context, groups []string, actions []DatabaseAuditAction) error

+ func (spec *DatabaseAuditSpecification) DropContext(ctx context.Context) error

+ func (spec *DatabaseAuditSpecification) SetAudit(auditName string) error

+ func (spec *DatabaseAuditSpecification) SetAuditContext(ctx context.Context, auditName string) error

+ func (spec *DatabaseAuditSpecification) SetState(on bool) error

+ func (spec *DatabaseAuditSpecification) SetStateContext(ctx context.Context, on bool) error

+ func (spec *DatabaseAuditSpecification) WithDisabled(ctx context.Context, fn func(context.Context) error) error

+ type DatabaseAuditSpecificationSpec struct

+ ActionGroups []string

+ Actions []DatabaseAuditAction

+ AuditName string

+ Enabled bool

+ Name string

type DatabaseCapabilities

+ ExplicitDatabasePermissions map[string]CapabilityState

+ ExplicitPrincipalPermissions map[string]map[string]CapabilityState

+ func (c *DatabaseCapabilities) DeniedOnDatabase(name string) bool

+ func (c *DatabaseCapabilities) DeniedOnPrincipal(principal, name string) bool

+ type DatabaseScopedCredential struct

+ CreateDate time.Time

+ CredentialID int

+ Identity string

+ ModifyDate time.Time

+ Name string

+ func (c *DatabaseScopedCredential) Alter(identity string, secret *string) error

+ func (c *DatabaseScopedCredential) AlterContext(ctx context.Context, identity string, secret *string) error

+ func (c *DatabaseScopedCredential) Database() *Database

+ func (c *DatabaseScopedCredential) Drop() error

+ func (c *DatabaseScopedCredential) DropContext(ctx context.Context) error

+ type DatabaseScopedCredentialSpec struct

+ Identity string

+ Name string

+ Secret string

+ type DatabaseTrigger struct

+ CreateDate time.Time

+ Definition string

+ Events []string

+ IsEnabled bool

+ ModifyDate time.Time

+ Name string

+ func (t *DatabaseTrigger) Database() *Database

+ func (t *DatabaseTrigger) Disable() error

+ func (t *DatabaseTrigger) DisableContext(ctx context.Context) error

+ func (t *DatabaseTrigger) Drop() error

+ func (t *DatabaseTrigger) DropContext(ctx context.Context) error

+ func (t *DatabaseTrigger) Enable() error

+ func (t *DatabaseTrigger) EnableContext(ctx context.Context) error

+ type EngineEdition int

+ const EngineAzureManagedInst

+ const EngineAzureSQLDatabase

+ const EngineAzureSQLEdge

+ const EngineAzureSynapse

+ const EngineAzureSynapseSrvls

+ const EngineEnterprise

+ const EngineExpress

+ const EnginePersonal

+ const EngineStandard

+ func (e EngineEdition) IsAzure() bool

type FileGroup

+ Type string

+ func (fg *FileGroup) IsFileStream() bool

+ type InstanceResourceGovernance struct

+ BufferPoolExtensionSizeGB int

+ CapCPU int

+ DataDirectoryQuotaMB int

+ DataDirectoryUsageMB int

+ ExternalXStoreIOPS int

+ ExternalXStoreMaxOutstandingIO int

+ LocalIOPS int

+ LocalMaxOutstandingIO int

+ ManagedXStoreIOPS int

+ ManagedXStoreMaxOutstandingIO int

+ MaxLogRate int64

+ MaxWorkerThreads int

+ ServerName string

+ TempDBLogFileNumber int

+ type OSJobObject struct

+ CPUAffinityGroup int

+ CPUAffinityMask int64

+ CPURate int

+ LowMemSignalThresholdMB int64

+ MemoryLimitMB int64

+ NonSOSMemGapMB int64

+ PeakJobMemoryUsedMB int64

+ PeakProcessMemoryUsedMB int64

+ ProcessMemoryLimitMB int64

+ ReadOperationCount int64

+ TotalKernelTime int64

+ TotalUserTime int64

+ WorkingSetLimitMB int64

+ WriteOperationCount int64

type RestoreOptions

+ Credential string

type Scripter

+ func (sc *Scripter) ScriptDatabaseAuditSpecification(name string) (string, error)

+ func (sc *Scripter) ScriptDatabaseAuditSpecificationContext(ctx context.Context, name string) (string, error)

+ func (sc *Scripter) ScriptDatabaseScopedCredential(name string) (string, error)

+ func (sc *Scripter) ScriptDatabaseScopedCredentialContext(ctx context.Context, name string) (string, error)

+ func (sc *Scripter) ScriptDatabaseTrigger(name string) (string, error)

+ func (sc *Scripter) ScriptDatabaseTriggerContext(ctx context.Context, name string) (string, error)

type Server

+ func (s *Server) DatabaseAuditActionGroups() ([]string, error)

+ func (s *Server) DatabaseAuditActionGroupsContext(ctx context.Context) ([]string, error)

+ func (s *Server) DatabaseAuditActions() ([]string, error)

+ func (s *Server) DatabaseAuditActionsContext(ctx context.Context) ([]string, error)

+ func (s *Server) InstanceResourceGovernance() (*InstanceResourceGovernance, error)

+ func (s *Server) InstanceResourceGovernanceContext(ctx context.Context) (*InstanceResourceGovernance, error)

+ func (s *Server) LatestServerResourceStats() (*ServerResourceStat, error)

+ func (s *Server) LatestServerResourceStatsContext(ctx context.Context) (*ServerResourceStat, error)

+ func (s *Server) OSJobObject() (*OSJobObject, error)

+ func (s *Server) OSJobObjectContext(ctx context.Context) (*OSJobObject, error)

+ func (s *Server) ServerResourceStats(max int) ([]*ServerResourceStat, error)

+ func (s *Server) ServerResourceStatsContext(ctx context.Context, max int) ([]*ServerResourceStat, error)

type ServerInfo

+ func (i *ServerInfo) IsAzure() bool

+ type ServerResourceStat struct

+ AvgCPUPercent float64

+ EndTime time.Time

+ HardwareGeneration string

+ IOBytesRead int64

+ IOBytesWritten int64

+ IORequests int64

+ ReservedStorageMB int64

+ ResourceName string

+ ResourceType string

+ SKU string

+ StartTime time.Time

+ StorageSpaceUsedMB float64

+ VirtualCoreCount int

+ type ServerSecurableKind string

+ const ServerSecurableEndpoint

+ const ServerSecurableLogin

+ const ServerSecurableServerRole

v0.0.11

Sep 4, 2026

Changes in this version

+ const AuditFailureContinue

+ const AuditFailureFailOp

+ const AuditFailureShutdown

+ const AuditToApplicationLog

+ const AuditToFile

+ const AuditToSecurityLog

+ const AuditUnlimited

+ const MinimumServerVersion

+ const QSDefaultTop

+ var ErrSystemEndpoint = errors.New("endpoint is a built-in system endpoint")

+ var ErrUnsupportedVersion = errors.New("unsupported server version")

+ var ProbedObjectPermissions = []string

+ var ProbedSchemaPermissions = []string

+ func ColumnKey(schema, object, column string) string

+ func ObjectKey(schema, object string) string

+ type AsymmetricKey struct

+ Algorithm string

+ KeyID int

+ KeyLength int

+ Name string

+ PrincipalID int

+ PvtKeyEncryptionType string

+ Thumbprint []byte

+ func (k *AsymmetricKey) HasPrivateKey() bool

+ type AttachSpec struct

+ Files []string

+ Name string

+ Owner string

+ RebuildLog bool

+ type BackupDevice struct

+ Name string

+ PhysicalName string

+ Type string

+ func (d *BackupDevice) Drop(deleteFile bool) error

+ func (d *BackupDevice) DropContext(ctx context.Context, deleteFile bool) error

+ func (d *BackupDevice) Headers() ([]*BackupHeader, error)

+ func (d *BackupDevice) HeadersContext(ctx context.Context) ([]*BackupHeader, error)

+ func (d *BackupDevice) Target() BackupTarget

+ type BackupDeviceType string

+ const BackupDeviceDisk

+ const BackupDeviceTape

+ type BackupTarget struct

+ func DeviceTarget(name string) BackupTarget

+ func DiskTarget(path string) BackupTarget

+ func (t BackupTarget) String() string

type ColumnEncryptionKey

+ func (cek *ColumnEncryptionKey) AddValue(value ColumnEncryptionKeyValue) error

+ func (cek *ColumnEncryptionKey) AddValueContext(ctx context.Context, value ColumnEncryptionKeyValue) error

+ func (cek *ColumnEncryptionKey) DropValue(masterKeyName string) error

+ func (cek *ColumnEncryptionKey) DropValueContext(ctx context.Context, masterKeyName string) error

type ConnectionOptions

+ Dialer mssql.Dialer

type CreateLoginOptions

+ ObjectID string

type Credential

+ CredentialID int

+ CryptographicProvider string

+ TargetType string

+ func (c *Credential) Alter(identity string, secret *string) error

+ func (c *Credential) AlterContext(ctx context.Context, identity string, secret *string) error

+ func (c *Credential) Drop() error

+ func (c *Credential) DropContext(ctx context.Context) error

+ type CredentialSpec struct

+ CryptographicProvider string

+ Identity string

+ Name string

+ Secret string

+ type CryptographicProvider struct

+ DLLPath string

+ GUID string

+ IsEnabled bool

+ Name string

+ ProviderID int

+ Version string

type Database

+ func (d *Database) AsymmetricKeyByName(name string) (*AsymmetricKey, error)

+ func (d *Database) AsymmetricKeyByNameContext(ctx context.Context, name string) (*AsymmetricKey, error)

+ func (d *Database) AsymmetricKeys() ([]*AsymmetricKey, error)

+ func (d *Database) AsymmetricKeysContext(ctx context.Context) ([]*AsymmetricKey, error)

+ func (d *Database) EnclaveComputationsSupported() bool

+ func (d *Database) QueryStoreForcePlan(queryID, planID int64) error

+ func (d *Database) QueryStoreForcePlanContext(ctx context.Context, queryID, planID int64) error

+ func (d *Database) QueryStoreForcedPlanQueries(opts QueryStoreReportOptions) ([]*QSQueryStat, error)

+ func (d *Database) QueryStoreForcedPlanQueriesContext(ctx context.Context, opts QueryStoreReportOptions) ([]*QSQueryStat, error)

+ func (d *Database) QueryStoreHighVariationQueries(opts QueryStoreReportOptions) ([]*QSQueryStat, error)

+ func (d *Database) QueryStoreHighVariationQueriesContext(ctx context.Context, opts QueryStoreReportOptions) ([]*QSQueryStat, error)

+ func (d *Database) QueryStoreMetrics() []QSMetric

+ func (d *Database) QueryStoreOverallConsumption(opts QueryStoreReportOptions) ([]*QSIntervalStat, error)

+ func (d *Database) QueryStoreOverallConsumptionContext(ctx context.Context, opts QueryStoreReportOptions) ([]*QSIntervalStat, error)

+ func (d *Database) QueryStorePlans(queryID int64, opts QueryStoreReportOptions) ([]*QSPlan, error)

+ func (d *Database) QueryStorePlansContext(ctx context.Context, queryID int64, opts QueryStoreReportOptions) ([]*QSPlan, error)

+ func (d *Database) QueryStoreQueryText(queryID int64) (text, objectName string, err error)

+ func (d *Database) QueryStoreQueryTextContext(ctx context.Context, queryID int64) (text, objectName string, err error)

+ func (d *Database) QueryStoreRegressedQueries(opts QueryStoreReportOptions) ([]*QSQueryStat, error)

+ func (d *Database) QueryStoreRegressedQueriesContext(ctx context.Context, opts QueryStoreReportOptions) ([]*QSQueryStat, error)

+ func (d *Database) QueryStoreTopResourceQueries(opts QueryStoreReportOptions) ([]*QSQueryStat, error)

+ func (d *Database) QueryStoreTopResourceQueriesContext(ctx context.Context, opts QueryStoreReportOptions) ([]*QSQueryStat, error)

+ func (d *Database) QueryStoreTrackedQuery(queryID int64, opts QueryStoreReportOptions) ([]*QSPlanIntervalStat, error)

+ func (d *Database) QueryStoreTrackedQueryContext(ctx context.Context, queryID int64, opts QueryStoreReportOptions) ([]*QSPlanIntervalStat, error)

+ func (d *Database) QueryStoreUnforcePlan(queryID, planID int64) error

+ func (d *Database) QueryStoreUnforcePlanContext(ctx context.Context, queryID, planID int64) error

+ func (d *Database) QueryStoreWaitCategories(opts QueryStoreReportOptions) ([]*QSWaitStat, error)

+ func (d *Database) QueryStoreWaitCategoriesContext(ctx context.Context, opts QueryStoreReportOptions) ([]*QSWaitStat, error)

+ func (d *Database) QueryStoreWaitStatsSupported() bool

+ func (d *Database) QueryStoreWaitingQueries(category string, opts QueryStoreReportOptions) ([]*QSQueryStat, error)

+ func (d *Database) QueryStoreWaitingQueriesContext(ctx context.Context, category string, opts QueryStoreReportOptions) ([]*QSQueryStat, error)

type DatabaseCapabilities

+ ColumnPermissions map[string]map[string]CapabilityState

+ ExplicitSchemaPermissions map[string]map[string]CapabilityState

+ ObjectPermissions map[string]map[string]CapabilityState

+ SchemaPermissions map[string]map[string]CapabilityState

+ func (c *DatabaseCapabilities) AllowsOnSchema(schema, name string) bool

+ func (c *DatabaseCapabilities) ColumnPermission(schema, object, column, name string) CapabilityState

+ func (c *DatabaseCapabilities) DeniedOnAnyColumn(schema, object, name string) (string, bool)

+ func (c *DatabaseCapabilities) DeniedOnColumn(schema, object, column, name string) bool

+ func (c *DatabaseCapabilities) DeniedOnObject(schema, object, name string) bool

+ func (c *DatabaseCapabilities) DeniedOnSchema(schema, name string) bool

+ func (c *DatabaseCapabilities) HasOnColumn(schema, object, column, name string) bool

+ func (c *DatabaseCapabilities) HasOnObject(schema, object, name string) bool

+ func (c *DatabaseCapabilities) HasOnSchema(schema, name string) bool

+ func (c *DatabaseCapabilities) ObjectPermission(schema, object, name string) CapabilityState

+ func (c *DatabaseCapabilities) PermitsOnSchema(schema, name string) bool

+ func (c *DatabaseCapabilities) Probed() bool

+ func (c *DatabaseCapabilities) SchemaPermission(schema, name string) CapabilityState

+ type DetachOptions struct

+ DropConnections bool

+ DropFullTextIndexFile bool

+ UpdateStatistics bool

+ type DetachedDatabase struct

+ Collation string

+ Files []*DetachedFile

+ Name string

+ Version string

+ func (d *DetachedDatabase) DataFiles() []*DetachedFile

+ func (d *DetachedDatabase) LogFiles() []*DetachedFile

+ func (d *DetachedDatabase) PrimaryFile() *DetachedFile

+ type DetachedFile struct

+ FileID int

+ IsLog bool

+ Name string

+ PhysicalName string

+ type Endpoint struct

+ EndpointID int

+ IsAdmin bool

+ IsSystem bool

+ Name string

+ Owner string

+ Port int

+ Protocol string

+ State string

+ Type string

+ func (e *Endpoint) Drop() error

+ func (e *Endpoint) DropContext(ctx context.Context) error

+ func (e *Endpoint) MirroringDetail() (*DatabaseMirroringEndpoint, error)

+ func (e *Endpoint) MirroringDetailContext(ctx context.Context) (*DatabaseMirroringEndpoint, error)

+ func (e *Endpoint) ServiceBrokerDetail() (*ServiceBrokerEndpointDetail, error)

+ func (e *Endpoint) ServiceBrokerDetailContext(ctx context.Context) (*ServiceBrokerEndpointDetail, error)

+ func (e *Endpoint) SetState(state EndpointState) error

+ func (e *Endpoint) SetStateContext(ctx context.Context, state EndpointState) error

+ type EndpointState string

+ const EndpointDisabled

+ const EndpointStarted

+ const EndpointStopped

type JobState

+ const JobStateUnknown

+ const JobStateWaitingForStepToFinish

+ type QSIntervalStat struct

+ EndTime time.Time

+ ExecCount int64

+ StartTime time.Time

+ Value float64

+ type QSMetric string

+ const QSMetricCLRTime

+ const QSMetricCPUTime

+ const QSMetricDOP

+ const QSMetricDuration

+ const QSMetricLogMemory

+ const QSMetricLogicalReads

+ const QSMetricLogicalWrites

+ const QSMetricMemory

+ const QSMetricPhysicalReads

+ const QSMetricRowCount

+ const QSMetricTempDBMemory

+ type QSPlan struct

+ CompatibilityLevel int

+ ExecCount int64

+ ForceFailureCount int64

+ ForcingType string

+ IsForced bool

+ IsParallelPlan bool

+ IsTrivialPlan bool

+ LastCompileStartTime time.Time

+ LastExecutionTime time.Time

+ LastForceFailureReason string

+ PlanID int64

+ QueryID int64

+ QueryPlanXML string

+ Value float64

+ type QSPlanIntervalStat struct

+ EndTime time.Time

+ ExecCount int64

+ PlanID int64

+ StartTime time.Time

+ Value float64

+ type QSQueryStat struct

+ BaselineExecCount int64

+ BaselineValue float64

+ ExecCount int64

+ ForcedPlanID int64

+ LastExecutionTime time.Time

+ ObjectName string

+ PlanCount int

+ QueryID int64

+ QueryText string

+ Regression float64

+ Value float64

+ Variation float64

+ type QSStatistic string

+ const QSStatAvg

+ const QSStatMax

+ const QSStatMin

+ const QSStatStdDev

+ const QSStatTotal

+ func QSStatistics() []QSStatistic

+ type QSUnit int

+ const QSUnitBytes

+ const QSUnitCount

+ const QSUnitMicroseconds

+ const QSUnitMilliseconds

+ const QSUnitPages

+ func QSMetricUnit(m QSMetric) (QSUnit, bool)

+ type QSWaitStat struct

+ Category string

+ ExecCount int64

+ Value float64

+ type QueryStoreReportOptions struct

+ BaselineFrom time.Time

+ BaselineTo time.Time

+ From time.Time

+ IncludeInternal bool

+ Metric QSMetric

+ MinExecCount int64

+ MinRegressionPct float64

+ QueryIDs []int64

+ Statistic QSStatistic

+ To time.Time

+ Top int

type Server

+ func (s *Server) AttachDatabase(spec AttachSpec) error

+ func (s *Server) AttachDatabaseContext(ctx context.Context, spec AttachSpec) error

+ func (s *Server) AuditActionGroups() ([]string, error)

+ func (s *Server) AuditActionGroupsContext(ctx context.Context) ([]string, error)

+ func (s *Server) BackupDevice(name string) *BackupDevice

+ func (s *Server) BackupDeviceByName(name string) (*BackupDevice, error)

+ func (s *Server) BackupDeviceByNameContext(ctx context.Context, name string) (*BackupDevice, error)

+ func (s *Server) BackupDeviceSeq(ctx context.Context) iter.Seq2[*BackupDevice, error]

+ func (s *Server) BackupDevices() ([]*BackupDevice, error)

+ func (s *Server) BackupDevicesContext(ctx context.Context) ([]*BackupDevice, error)

+ func (s *Server) BackupFileListForSetFrom(target BackupTarget, fileNumber int) ([]*BackupFile, error)

+ func (s *Server) BackupFileListForSetFromContext(ctx context.Context, target BackupTarget, fileNumber int) ([]*BackupFile, error)

+ func (s *Server) BackupHeadersFrom(target BackupTarget) ([]*BackupHeader, error)

+ func (s *Server) BackupHeadersFromContext(ctx context.Context, target BackupTarget) ([]*BackupHeader, error)

+ func (s *Server) CreateBackupDevice(name string, devType BackupDeviceType, physicalName string) (*BackupDevice, error)

+ func (s *Server) CreateBackupDeviceContext(ctx context.Context, name string, devType BackupDeviceType, ...) (*BackupDevice, error)

+ func (s *Server) CreateCredential(spec CredentialSpec) (*Credential, error)

+ func (s *Server) CreateCredentialContext(ctx context.Context, spec CredentialSpec) (*Credential, error)

+ func (s *Server) CreateServerAudit(spec ServerAuditSpec) (*ServerAudit, error)

+ func (s *Server) CreateServerAuditContext(ctx context.Context, spec ServerAuditSpec) (*ServerAudit, error)

+ func (s *Server) CreateServerAuditSpecification(spec ServerAuditSpecificationSpec) (*ServerAuditSpecification, error)

+ func (s *Server) CreateServerAuditSpecificationContext(ctx context.Context, spec ServerAuditSpecificationSpec) (*ServerAuditSpecification, error)

+ func (s *Server) Credential(name string) *Credential

+ func (s *Server) CredentialByName(name string) (*Credential, error)

+ func (s *Server) CredentialByNameContext(ctx context.Context, name string) (*Credential, error)

+ func (s *Server) CryptographicProviders() ([]*CryptographicProvider, error)

+ func (s *Server) CryptographicProvidersContext(ctx context.Context) ([]*CryptographicProvider, error)

+ func (s *Server) DatabaseFiles(database string) ([]*DatabaseFileInfo, error)

+ func (s *Server) DatabaseFilesContext(ctx context.Context, database string) ([]*DatabaseFileInfo, error)

+ func (s *Server) DetachDatabase(name string, opts DetachOptions) error

+ func (s *Server) DetachDatabaseContext(ctx context.Context, name string, opts DetachOptions) error

+ func (s *Server) DetachedDatabaseInfo(primaryFilePath string) (*DetachedDatabase, error)

+ func (s *Server) DetachedDatabaseInfoContext(ctx context.Context, primaryFilePath string) (*DetachedDatabase, error)

+ func (s *Server) EndpointByName(name string) (*Endpoint, error)

+ func (s *Server) EndpointByNameContext(ctx context.Context, name string) (*Endpoint, error)

+ func (s *Server) EndpointSeq(ctx context.Context) iter.Seq2[*Endpoint, error]

+ func (s *Server) Endpoints() ([]*Endpoint, error)

+ func (s *Server) EndpointsContext(ctx context.Context) ([]*Endpoint, error)

+ func (s *Server) ServerAudit(name string) *ServerAudit

+ func (s *Server) ServerAuditByName(name string) (*ServerAudit, error)

+ func (s *Server) ServerAuditByNameContext(ctx context.Context, name string) (*ServerAudit, error)

+ func (s *Server) ServerAuditSeq(ctx context.Context) iter.Seq2[*ServerAudit, error]

+ func (s *Server) ServerAuditSpecification(name string) *ServerAuditSpecification

+ func (s *Server) ServerAuditSpecificationByName(name string) (*ServerAuditSpecification, error)

+ func (s *Server) ServerAuditSpecificationByNameContext(ctx context.Context, name string) (*ServerAuditSpecification, error)

+ func (s *Server) ServerAuditSpecificationSeq(ctx context.Context) iter.Seq2[*ServerAuditSpecification, error]

+ func (s *Server) ServerAuditSpecifications() ([]*ServerAuditSpecification, error)

+ func (s *Server) ServerAuditSpecificationsContext(ctx context.Context) ([]*ServerAuditSpecification, error)

+ func (s *Server) ServerAudits() ([]*ServerAudit, error)

+ func (s *Server) ServerAuditsContext(ctx context.Context) ([]*ServerAudit, error)

+ func (s *Server) ServerTrigger(name string) *ServerTrigger

+ func (s *Server) ServerTriggerByName(name string) (*ServerTrigger, error)

+ func (s *Server) ServerTriggerByNameContext(ctx context.Context, name string) (*ServerTrigger, error)

+ func (s *Server) ServerTriggerSeq(ctx context.Context) iter.Seq2[*ServerTrigger, error]

+ func (s *Server) ServerTriggers() ([]*ServerTrigger, error)

+ func (s *Server) ServerTriggersContext(ctx context.Context) ([]*ServerTrigger, error)

+ func (s *Server) VerifyBackupFrom(target BackupTarget) error

+ func (s *Server) VerifyBackupFromContext(ctx context.Context, target BackupTarget) error

+ type ServerAudit struct

+ AuditID int

+ CreateDate time.Time

+ GUID string

+ IsEnabled bool

+ LogFileName string

+ LogFilePath string

+ MaxFileSize int64

+ MaxFiles int

+ MaxRolloverFiles int

+ ModifyDate time.Time

+ Name string

+ OnFailure string

+ Predicate string

+ QueueDelay int

+ ReserveDiskSpace bool

+ Type string

+ func (a *ServerAudit) Alter(spec ServerAuditSpec) error

+ func (a *ServerAudit) AlterContext(ctx context.Context, spec ServerAuditSpec) error

+ func (a *ServerAudit) Drop() error

+ func (a *ServerAudit) DropContext(ctx context.Context) error

+ func (a *ServerAudit) Rename(newName string) error

+ func (a *ServerAudit) RenameContext(ctx context.Context, newName string) error

+ func (a *ServerAudit) SetState(on bool) error

+ func (a *ServerAudit) SetStateContext(ctx context.Context, on bool) error

+ func (a *ServerAudit) Status() (*ServerAuditStatus, error)

+ func (a *ServerAudit) StatusContext(ctx context.Context) (*ServerAuditStatus, error)

+ func (a *ServerAudit) WithDisabled(ctx context.Context, fn func(context.Context) error) error

+ type ServerAuditSpec struct

+ FilePath string

+ MaxFileSize int64

+ MaxFiles int

+ MaxRolloverFiles int

+ Name string

+ OnFailure string

+ Predicate string

+ QueueDelay int

+ ReserveDiskSpace bool

+ Type string

+ type ServerAuditSpecification struct

+ ActionGroups []string

+ AuditGUID string

+ AuditName string

+ CreateDate time.Time

+ IsEnabled bool

+ ModifyDate time.Time

+ Name string

+ SpecificationID int

+ func (spec *ServerAuditSpecification) AddActionGroups(groups ...string) error

+ func (spec *ServerAuditSpecification) AddActionGroupsContext(ctx context.Context, groups ...string) error

+ func (spec *ServerAuditSpecification) Drop() error

+ func (spec *ServerAuditSpecification) DropActionGroups(groups ...string) error

+ func (spec *ServerAuditSpecification) DropActionGroupsContext(ctx context.Context, groups ...string) error

+ func (spec *ServerAuditSpecification) DropContext(ctx context.Context) error

+ func (spec *ServerAuditSpecification) SetAudit(auditName string) error

+ func (spec *ServerAuditSpecification) SetAuditContext(ctx context.Context, auditName string) error

+ func (spec *ServerAuditSpecification) SetState(on bool) error

+ func (spec *ServerAuditSpecification) SetStateContext(ctx context.Context, on bool) error

+ func (spec *ServerAuditSpecification) WithDisabled(ctx context.Context, fn func(context.Context) error) error

+ type ServerAuditSpecificationSpec struct

+ ActionGroups []string

+ AuditName string

+ Enabled bool

+ Name string

+ type ServerAuditStatus struct

+ AuditFilePath string

+ AuditFileSize int64

+ Status string

+ StatusTime time.Time

type ServerScripter

+ func (sc *ServerScripter) ScriptBackupDevice(name string) (string, error)

+ func (sc *ServerScripter) ScriptBackupDeviceContext(ctx context.Context, name string) (string, error)

+ func (sc *ServerScripter) ScriptCredential(name string) (string, error)

+ func (sc *ServerScripter) ScriptCredentialContext(ctx context.Context, name string) (string, error)

+ func (sc *ServerScripter) ScriptEndpoint(name string) (string, error)

+ func (sc *ServerScripter) ScriptEndpointContext(ctx context.Context, name string) (string, error)

+ func (sc *ServerScripter) ScriptServerAudit(name string) (string, error)

+ func (sc *ServerScripter) ScriptServerAuditContext(ctx context.Context, name string) (string, error)

+ func (sc *ServerScripter) ScriptServerAuditSpecification(name string) (string, error)

+ func (sc *ServerScripter) ScriptServerAuditSpecificationContext(ctx context.Context, name string) (string, error)

+ func (sc *ServerScripter) ScriptServerTrigger(name string) (string, error)

+ func (sc *ServerScripter) ScriptServerTriggerContext(ctx context.Context, name string) (string, error)

+ type ServerTrigger struct

+ CreateDate time.Time

+ Definition string

+ Events []string

+ IsEnabled bool

+ ModifyDate time.Time

+ Name string

+ func (t *ServerTrigger) Disable() error

+ func (t *ServerTrigger) DisableContext(ctx context.Context) error

+ func (t *ServerTrigger) Drop() error

+ func (t *ServerTrigger) DropContext(ctx context.Context) error

+ func (t *ServerTrigger) Enable() error

+ func (t *ServerTrigger) EnableContext(ctx context.Context) error

type ServerVersion

+ const SQLServer2025

+ type ServiceBrokerEndpointDetail struct

+ CertificateName string

+ ConnectionAuth string

+ EncryptionAlgorithm string

+ IsMessageForwardingEnabled bool

+ MessageForwardingSize int

v0.0.10

Aug 25, 2026

Changes in this version

+ var ProbedDatabasePermissions = []string

+ var ProbedDatabaseRoles = []string

+ var ProbedServerPermissions = []string

+ var ProbedServerRoles = []string

+ type Capabilities struct

+ ServerPermissions map[string]CapabilityState

+ ServerRoles map[string]bool

+ func (c *Capabilities) Allows(name string) bool

+ func (c *Capabilities) Has(name string) bool

+ func (c *Capabilities) InServerRole(name string) bool

+ func (c *Capabilities) IsSysadmin() bool

+ func (c *Capabilities) Permission(name string) CapabilityState

+ func (c *Capabilities) Probed() bool

+ type CapabilityState int

+ const CapabilityDenied

+ const CapabilityGranted

+ const CapabilityUnknown

+ func (s CapabilityState) String() string

type ColumnEncryptionKey

+ Values []*ColumnEncryptionKeyValue

+ type ColumnEncryptionKeyValue struct

+ EncryptedValue []byte

+ EncryptionAlgorithm string

+ MasterKeyName string

type ColumnMasterKey

+ Signature []byte

type CreateIndexRequest

+ BoundingBox *SpatialBoundingBox

+ CellsPerObject int

+ CompressionDelay int

+ DataCompression string

+ DropExisting bool

+ FileGroup string

+ GridLevels SpatialGridLevels

+ IsPrimaryXML bool

+ PadIndex bool

+ PartitionColumns []string

+ PartitionScheme string

+ PrimaryXMLIndex string

+ SecondaryXMLType XMLSecondaryIndexType

+ Tessellation SpatialTessellation

type CreateLoginOptions

+ AsymmetricKeyName string

+ CertificateName string

+ Source LoginSource

+ type CreateStatisticRequest struct

+ Columns []string

+ FilterDefinition string

+ FullScan bool

+ Incremental bool

+ Name string

+ NoRecompute bool

+ SamplePercent int

+ type DataSpace struct

+ IsDefaultFileGroup bool

+ IsPartitionScheme bool

+ Name string

+ PartitionColumn string

type Database

+ func (d *Database) Capabilities() (*DatabaseCapabilities, error)

+ func (d *Database) CapabilitiesContext(ctx context.Context) (*DatabaseCapabilities, error)

+ func (d *Database) ColumnEncryptionKeyByName(name string) (*ColumnEncryptionKey, error)

+ func (d *Database) ColumnEncryptionKeyByNameContext(ctx context.Context, name string) (*ColumnEncryptionKey, error)

+ func (d *Database) ColumnMasterKeyByName(name string) (*ColumnMasterKey, error)

+ func (d *Database) ColumnMasterKeyByNameContext(ctx context.Context, name string) (*ColumnMasterKey, error)

+ func (d *Database) CreateColumnEncryptionKey(name string, values []ColumnEncryptionKeyValue) error

+ func (d *Database) CreateColumnEncryptionKeyContext(ctx context.Context, name string, values []ColumnEncryptionKeyValue) error

+ func (d *Database) CreateColumnMasterKeyWithSignature(name, keyStoreProvider, keyPath string, signature []byte) error

+ func (d *Database) CreateColumnMasterKeyWithSignatureContext(ctx context.Context, name, keyStoreProvider, keyPath string, signature []byte) error

+ func (d *Database) ParameterSeq(ctx context.Context, schema, name string) iter.Seq2[*Parameter, error]

+ func (d *Database) Parameters(schema, name string) ([]*Parameter, error)

+ func (d *Database) ParametersContext(ctx context.Context, schema, name string) ([]*Parameter, error)

+ func (d *Database) PartitionFunctionByName(name string) (*PartitionFunction, error)

+ func (d *Database) PartitionFunctionByNameContext(ctx context.Context, name string) (*PartitionFunction, error)

+ func (d *Database) PartitionSchemeByName(name string) (*PartitionScheme, error)

+ func (d *Database) PartitionSchemeByNameContext(ctx context.Context, name string) (*PartitionScheme, error)

+ func (d *Database) RecoveryStatus() (*DatabaseRecoveryStatus, error)

+ func (d *Database) RecoveryStatusContext(ctx context.Context) (*DatabaseRecoveryStatus, error)

+ func (d *Database) SchemaByName(name string) (*Schema, error)

+ func (d *Database) SchemaByNameContext(ctx context.Context, name string) (*Schema, error)

+ func (d *Database) SecurityPolicyByName(schema, name string) (*SecurityPolicy, error)

+ func (d *Database) SecurityPolicyByNameContext(ctx context.Context, schema, name string) (*SecurityPolicy, error)

+ func (d *Database) StoredProceduresFiltered(filter ObjectFilter) ([]*StoredProcedure, error)

+ func (d *Database) StoredProceduresFilteredContext(ctx context.Context, filter ObjectFilter) ([]*StoredProcedure, error)

+ func (d *Database) SystemFunctionsFiltered(filter ObjectFilter) ([]*UserDefinedFunction, error)

+ func (d *Database) SystemFunctionsFilteredContext(ctx context.Context, filter ObjectFilter) ([]*UserDefinedFunction, error)

+ func (d *Database) SystemStoredProceduresFiltered(filter ObjectFilter) ([]*StoredProcedure, error)

+ func (d *Database) SystemStoredProceduresFilteredContext(ctx context.Context, filter ObjectFilter) ([]*StoredProcedure, error)

+ func (d *Database) SystemViewsFiltered(filter ObjectFilter) ([]*View, error)

+ func (d *Database) SystemViewsFilteredContext(ctx context.Context, filter ObjectFilter) ([]*View, error)

+ func (d *Database) TableChangeTrackingFor(schema, name string) (*TableChangeTracking, error)

+ func (d *Database) TableChangeTrackingForContext(ctx context.Context, schema, name string) (*TableChangeTracking, error)

+ func (d *Database) TablesFiltered(filter ObjectFilter) ([]*Table, error)

+ func (d *Database) TablesFilteredContext(ctx context.Context, filter ObjectFilter) ([]*Table, error)

+ func (d *Database) TransferObject(targetSchema, schema, name string) error

+ func (d *Database) TransferObjectContext(ctx context.Context, targetSchema, schema, name string) error

+ func (d *Database) UserDefinedFunctionsFiltered(filter ObjectFilter) ([]*UserDefinedFunction, error)

+ func (d *Database) UserDefinedFunctionsFilteredContext(ctx context.Context, filter ObjectFilter) ([]*UserDefinedFunction, error)

+ func (d *Database) ViewsFiltered(filter ObjectFilter) ([]*View, error)

+ func (d *Database) ViewsFilteredContext(ctx context.Context, filter ObjectFilter) ([]*View, error)

+ type DatabaseCapabilities struct

+ Accessible bool

+ Permissions map[string]CapabilityState

+ Roles map[string]bool

+ func (c *DatabaseCapabilities) Allows(name string) bool

+ func (c *DatabaseCapabilities) Has(name string) bool

+ func (c *DatabaseCapabilities) InRole(name string) bool

+ func (c *DatabaseCapabilities) Permission(name string) CapabilityState

+ func (c *DatabaseCapabilities) Permits(name string) bool

type DatabaseFileSpec

+ DisableGrowth bool

+ type DatabaseRecoveryStatus struct

+ DatabaseName string

+ LastLogBackupLSN string

+ LogBackupChainStarted bool

+ type DateCriterion struct

+ Day time.Time

+ Op DateOp

+ type DateOp int

+ const DateAfter

+ const DateBefore

+ const DateOn

type ExecutionPlan

+ All []string

type FileModify

+ DisableGrowth bool

type Index

+ DataSpace DataSpace

type Job

+ func (j *Job) InsertStep(req JobStepRequest, stepID int) error

+ func (j *Job) InsertStepContext(ctx context.Context, req JobStepRequest, stepID int) error

+ func (j *Job) MoveStep(stepID, newStepID int) error

+ func (j *Job) MoveStepContext(ctx context.Context, stepID, newStepID int) error

+ func (j *Job) ReorderSteps(order func(n int) []int) error

+ func (j *Job) ReorderStepsContext(ctx context.Context, order func(n int) []int) error

type JobStep

+ AdditionalParameters string

+ CmdExecSuccessCode int

+ DatabaseUserName string

+ OSRunPriority int

+ ProxyName string

+ Server string

+ func (s *JobStep) SetFlow(onSuccessAction, onSuccessStepID, onFailAction, onFailStepID int) error

+ func (s *JobStep) SetFlowContext(ctx context.Context, ...) error

type JobStepRequest

+ AdditionalParameters string

+ CmdExecSuccessCode int

+ DatabaseUserName string

+ Flags int

+ OSRunPriority int

+ ProxyName string

+ Server string

+ type LogSearch struct

+ From time.Time

+ Text1 string

+ Text2 string

+ To time.Time

type Login

+ MappedObject string

+ func (l *Login) ResolveMapping() error

+ func (l *Login) ResolveMappingContext(ctx context.Context) error

+ type LoginSource int

+ const LoginSourceAsymmetricKey

+ const LoginSourceAuto

+ const LoginSourceCertificate

+ const LoginSourceExternalProvider

+ const LoginSourceSQL

+ const LoginSourceWindows

+ func (src LoginSource) String() string

+ type ObjectFilter struct

+ Created []DateCriterion

+ MemoryOptimized *bool

+ Name []TextCriterion

+ Schema []TextCriterion

+ func (f ObjectFilter) Empty() bool

+ type Parameter struct

+ DataType DataType

+ HasDefault bool

+ IsOutput bool

+ MaxLength int

+ Name string

+ Ordinal int

+ Precision int

+ Scale int

+ func (p *Parameter) TypeString() string

type Schema

+ func (s *Schema) ObjectCountsByType() (SchemaObjectCounts, error)

+ func (s *Schema) ObjectCountsByTypeContext(ctx context.Context) (SchemaObjectCounts, error)

+ type SchemaObjectCounts struct

+ Functions int

+ Sequences int

+ StoredProcedures int

+ Synonyms int

+ Tables int

+ Views int

type ScriptOptions

+ Verb ScriptVerb

+ type ScriptVerb int

+ const ScriptAlter

+ const ScriptCreate

+ const ScriptDrop

+ const ScriptDropAndCreate

type Scripter

+ func (sc *Scripter) ScriptCheckConstraint(schema, table, name string) (string, error)

+ func (sc *Scripter) ScriptCheckConstraintContext(ctx context.Context, schema, table, name string) (string, error)

+ func (sc *Scripter) ScriptColumnEncryptionKey(name string) (string, error)

+ func (sc *Scripter) ScriptColumnEncryptionKeyContext(ctx context.Context, name string) (string, error)

+ func (sc *Scripter) ScriptColumnMasterKey(name string) (string, error)

+ func (sc *Scripter) ScriptColumnMasterKeyContext(ctx context.Context, name string) (string, error)

+ func (sc *Scripter) ScriptDatabaseContext(ctx context.Context) (string, error)

+ func (sc *Scripter) ScriptDatabaseRole(name string) (string, error)

+ func (sc *Scripter) ScriptDatabaseRoleContext(ctx context.Context, name string) (string, error)

+ func (sc *Scripter) ScriptDelete(schema, name string) (string, error)

+ func (sc *Scripter) ScriptDeleteContext(ctx context.Context, schema, name string) (string, error)

+ func (sc *Scripter) ScriptExecute(schema, name string) (string, error)

+ func (sc *Scripter) ScriptExecuteContext(ctx context.Context, schema, name string) (string, error)

+ func (sc *Scripter) ScriptForeignKey(schema, table, name string) (string, error)

+ func (sc *Scripter) ScriptForeignKeyContext(ctx context.Context, schema, table, name string) (string, error)

+ func (sc *Scripter) ScriptFunctionCall(schema, name, funcType string) (string, error)

+ func (sc *Scripter) ScriptFunctionCallContext(ctx context.Context, schema, name, funcType string) (string, error)

+ func (sc *Scripter) ScriptIndex(schema, table, name string) (string, error)

+ func (sc *Scripter) ScriptIndexContext(ctx context.Context, schema, table, name string) (string, error)

+ func (sc *Scripter) ScriptInsert(schema, name string) (string, error)

+ func (sc *Scripter) ScriptInsertContext(ctx context.Context, schema, name string) (string, error)

+ func (sc *Scripter) ScriptPartitionFunction(name string) (string, error)

+ func (sc *Scripter) ScriptPartitionFunctionContext(ctx context.Context, name string) (string, error)

+ func (sc *Scripter) ScriptPartitionScheme(name string) (string, error)

+ func (sc *Scripter) ScriptPartitionSchemeContext(ctx context.Context, name string) (string, error)

+ func (sc *Scripter) ScriptSchema(name string) (string, error)

+ func (sc *Scripter) ScriptSchemaContext(ctx context.Context, name string) (string, error)

+ func (sc *Scripter) ScriptSecurityPolicy(schema, name string) (string, error)

+ func (sc *Scripter) ScriptSecurityPolicyContext(ctx context.Context, schema, name string) (string, error)

+ func (sc *Scripter) ScriptSelect(schema, name string) (string, error)

+ func (sc *Scripter) ScriptSelectContext(ctx context.Context, schema, name string) (string, error)

+ func (sc *Scripter) ScriptSequence(schema, name string) (string, error)

+ func (sc *Scripter) ScriptSequenceContext(ctx context.Context, schema, name string) (string, error)

+ func (sc *Scripter) ScriptSynonym(schema, name string) (string, error)

+ func (sc *Scripter) ScriptSynonymContext(ctx context.Context, schema, name string) (string, error)

+ func (sc *Scripter) ScriptTrigger(schema, name string) (string, error)

+ func (sc *Scripter) ScriptTriggerContext(ctx context.Context, schema, name string) (string, error)

+ func (sc *Scripter) ScriptUpdate(schema, name string) (string, error)

+ func (sc *Scripter) ScriptUpdateContext(ctx context.Context, schema, name string) (string, error)

+ func (sc *Scripter) ScriptUser(name string) (string, error)

+ func (sc *Scripter) ScriptUserContext(ctx context.Context, name string) (string, error)

type SecurityPolicy

+ IsSchemaBound bool

type Server

+ func NewServer(ctx context.Context, db *sql.DB) (*Server, error)

+ func (s *Server) Capabilities() (*Capabilities, error)

+ func (s *Server) CapabilitiesContext(ctx context.Context) (*Capabilities, error)

+ func (s *Server) CycleLog(logType ErrorLogType) error

+ func (s *Server) CycleLogContext(ctx context.Context, logType ErrorLogType) error

+ func (s *Server) DatabaseRecoveryStatuses() ([]*DatabaseRecoveryStatus, error)

+ func (s *Server) DatabaseRecoveryStatusesContext(ctx context.Context) ([]*DatabaseRecoveryStatus, error)

+ func (s *Server) EnumFileSystemIsLegacy() bool

+ func (s *Server) ReadLogFiltered(logType ErrorLogType, logNumber int, search LogSearch) ([]*ErrorLogEntry, error)

+ func (s *Server) ReadLogFilteredContext(ctx context.Context, logType ErrorLogType, logNumber int, search LogSearch) ([]*ErrorLogEntry, error)

type ServerInfo

+ SysInfoUnavailable bool

+ type ServerScripter struct

+ func NewServerScripter(s *Server, opts ScriptOptions) *ServerScripter

+ func (sc *ServerScripter) ScriptLogin(name string) (string, error)

+ func (sc *ServerScripter) ScriptLoginContext(ctx context.Context, name string) (string, error)

+ func (sc *ServerScripter) ScriptServerRole(name string) (string, error)

+ func (sc *ServerScripter) ScriptServerRoleContext(ctx context.Context, name string) (string, error)

+ type SpatialBoundingBox struct

+ XMax float64

+ XMin float64

+ YMax float64

+ YMin float64

+ type SpatialGridDensity string

+ const SpatialGridHigh

+ const SpatialGridLow

+ const SpatialGridMedium

+ type SpatialGridLevels struct

+ Level1 SpatialGridDensity

+ Level2 SpatialGridDensity

+ Level3 SpatialGridDensity

+ Level4 SpatialGridDensity

+ type SpatialTessellation string

+ const SpatialGeographyAutoGrid

+ const SpatialGeographyGrid

+ const SpatialGeometryAutoGrid

+ const SpatialGeometryGrid

+ func (s SpatialTessellation) IsAutoGrid() bool

+ func (s SpatialTessellation) IsGeometry() bool

type Table

+ func (t *Table) CreateStatisticWithOptions(req CreateStatisticRequest) error

+ func (t *Table) CreateStatisticWithOptionsContext(ctx context.Context, req CreateStatisticRequest) error

+ func (t *Table) DataSpace() (DataSpace, error)

+ func (t *Table) DataSpaceContext(ctx context.Context) (DataSpace, error)

+ func (t *Table) ForeignKeyByName(name string) (*ForeignKey, error)

+ func (t *Table) ForeignKeyByNameContext(ctx context.Context, name string) (*ForeignKey, error)

+ func (t *Table) IndexByName(name string) (*Index, error)

+ func (t *Table) IndexByNameContext(ctx context.Context, name string) (*Index, error)

+ func (t *Table) RenameColumn(name, newName string) error

+ func (t *Table) RenameColumnContext(ctx context.Context, name, newName string) error

+ func (t *Table) StatisticByName(name string) (*Statistic, error)

+ func (t *Table) StatisticByNameContext(ctx context.Context, name string) (*Statistic, error)

+ func (t *Table) XMLIndexSeq(ctx context.Context) iter.Seq2[*XMLIndex, error]

+ func (t *Table) XMLIndexes() ([]*XMLIndex, error)

+ func (t *Table) XMLIndexesContext(ctx context.Context) ([]*XMLIndex, error)

+ type TextCriterion struct

+ Op TextOp

+ Value string

+ type TextOp int

+ const TextContains

+ const TextEquals

+ const TextNotContains

+ const TextNotEquals

+ type XMLIndex struct

+ ColumnName string

+ IndexID int

+ IsPrimary bool

+ Name string

+ PrimaryIndexName string

+ SecondaryType XMLSecondaryIndexType

+ type XMLSecondaryIndexType string

+ const XMLSecondaryPath

+ const XMLSecondaryProperty

+ const XMLSecondaryValue

v0.0.9

Aug 18, 2026

Changes in this version

+ var ErrNotFound = errors.New("not found")

+ type AvailabilityDatabase struct

+ DatabaseName string

+ DatabaseState string

+ GroupDatabaseID string

+ GroupID string

+ IsLocal bool

+ IsPrimaryReplica bool

+ IsSuspended bool

+ LastCommitTime time.Time

+ LastHardenedTime time.Time

+ LastReceivedTime time.Time

+ LastRedoneTime time.Time

+ LastSentTime time.Time

+ LogSendQueueKB int64

+ LogSendRateKBps int64

+ RedoQueueKB int64

+ RedoRateKBps int64

+ ReplicaID string

+ ReplicaServerName string

+ SecondaryLagSeconds int64

+ SuspendReason string

+ SynchronizationHealth string

+ SynchronizationState string

+ type AvailabilityGroup struct

+ AutomatedBackupPreference string

+ BasicFeatures bool

+ ClusterType string

+ DBFailover bool

+ DTCSupport bool

+ FailureConditionLevel int

+ HealthCheckTimeout int

+ ID string

+ IsContained bool

+ IsDistributed bool

+ Name string

+ PrimaryRecoveryHealth string

+ PrimaryReplicaServerName string

+ RequiredSynchronizedSecondariesToCommit int

+ ResourceGroupID string

+ ResourceID string

+ SynchronizationHealth string

+ Version int

+ func (ag *AvailabilityGroup) AddDatabase(name string) error

+ func (ag *AvailabilityGroup) AddDatabaseContext(ctx context.Context, name string) error

+ func (ag *AvailabilityGroup) AddListener(spec AvailabilityListenerSpec) error

+ func (ag *AvailabilityGroup) AddListenerContext(ctx context.Context, spec AvailabilityListenerSpec) error

+ func (ag *AvailabilityGroup) AddListenerIP(dnsName string, ip AvailabilityListenerIPSpec) error

+ func (ag *AvailabilityGroup) AddListenerIPContext(ctx context.Context, dnsName string, ip AvailabilityListenerIPSpec) error

+ func (ag *AvailabilityGroup) AddReplica(spec AvailabilityReplicaSpec) error

+ func (ag *AvailabilityGroup) AddReplicaContext(ctx context.Context, spec AvailabilityReplicaSpec) error

+ func (ag *AvailabilityGroup) DatabaseSeq(ctx context.Context) iter.Seq2[*AvailabilityDatabase, error]

+ func (ag *AvailabilityGroup) Databases() ([]*AvailabilityDatabase, error)

+ func (ag *AvailabilityGroup) DatabasesContext(ctx context.Context) ([]*AvailabilityDatabase, error)

+ func (ag *AvailabilityGroup) DenyCreateAnyDatabase() error

+ func (ag *AvailabilityGroup) DenyCreateAnyDatabaseContext(ctx context.Context) error

+ func (ag *AvailabilityGroup) Drop() error

+ func (ag *AvailabilityGroup) DropContext(ctx context.Context) error

+ func (ag *AvailabilityGroup) Failover() error

+ func (ag *AvailabilityGroup) FailoverContext(ctx context.Context) error

+ func (ag *AvailabilityGroup) ForceFailoverAllowDataLoss() error

+ func (ag *AvailabilityGroup) ForceFailoverAllowDataLossContext(ctx context.Context) error

+ func (ag *AvailabilityGroup) GrantCreateAnyDatabase() error

+ func (ag *AvailabilityGroup) GrantCreateAnyDatabaseContext(ctx context.Context) error

+ func (ag *AvailabilityGroup) IsLocalPrimary() bool

+ func (ag *AvailabilityGroup) Join(clusterType string) error

+ func (ag *AvailabilityGroup) JoinContext(ctx context.Context, clusterType string) error

+ func (ag *AvailabilityGroup) JoinDatabase(name string) error

+ func (ag *AvailabilityGroup) JoinDatabaseContext(ctx context.Context, name string) error

+ func (ag *AvailabilityGroup) ListenerSeq(ctx context.Context) iter.Seq2[*AvailabilityGroupListener, error]

+ func (ag *AvailabilityGroup) Listeners() ([]*AvailabilityGroupListener, error)

+ func (ag *AvailabilityGroup) ListenersContext(ctx context.Context) ([]*AvailabilityGroupListener, error)

+ func (ag *AvailabilityGroup) RemoveDatabase(name string) error

+ func (ag *AvailabilityGroup) RemoveDatabaseContext(ctx context.Context, name string) error

+ func (ag *AvailabilityGroup) RemoveListener(dnsName string) error

+ func (ag *AvailabilityGroup) RemoveListenerContext(ctx context.Context, dnsName string) error

+ func (ag *AvailabilityGroup) RemoveReplica(serverName string) error

+ func (ag *AvailabilityGroup) RemoveReplicaContext(ctx context.Context, serverName string) error

+ func (ag *AvailabilityGroup) ReplicaSeq(ctx context.Context) iter.Seq2[*AvailabilityReplica, error]

+ func (ag *AvailabilityGroup) Replicas() ([]*AvailabilityReplica, error)

+ func (ag *AvailabilityGroup) ReplicasContext(ctx context.Context) ([]*AvailabilityReplica, error)

+ func (ag *AvailabilityGroup) ResumeDatabase(name string) error

+ func (ag *AvailabilityGroup) ResumeDatabaseContext(ctx context.Context, name string) error

+ func (ag *AvailabilityGroup) Server() *Server

+ func (ag *AvailabilityGroup) SetAutomatedBackupPreference(pref string) error

+ func (ag *AvailabilityGroup) SetAutomatedBackupPreferenceContext(ctx context.Context, pref string) error

+ func (ag *AvailabilityGroup) SetDBFailover(on bool) error

+ func (ag *AvailabilityGroup) SetDBFailoverContext(ctx context.Context, on bool) error

+ func (ag *AvailabilityGroup) SetDTCSupport(perDB bool) error

+ func (ag *AvailabilityGroup) SetDTCSupportContext(ctx context.Context, perDB bool) error

+ func (ag *AvailabilityGroup) SetFailureConditionLevel(level int) error

+ func (ag *AvailabilityGroup) SetFailureConditionLevelContext(ctx context.Context, level int) error

+ func (ag *AvailabilityGroup) SetHealthCheckTimeout(ms int) error

+ func (ag *AvailabilityGroup) SetHealthCheckTimeoutContext(ctx context.Context, ms int) error

+ func (ag *AvailabilityGroup) SetListenerPort(dnsName string, port int) error

+ func (ag *AvailabilityGroup) SetListenerPortContext(ctx context.Context, dnsName string, port int) error

+ func (ag *AvailabilityGroup) SetRequiredSynchronizedSecondariesToCommit(n int) error

+ func (ag *AvailabilityGroup) SetRequiredSynchronizedSecondariesToCommitContext(ctx context.Context, n int) error

+ func (ag *AvailabilityGroup) SuspendDatabase(name string) error

+ func (ag *AvailabilityGroup) SuspendDatabaseContext(ctx context.Context, name string) error

+ func (ag *AvailabilityGroup) UnjoinDatabase(name string) error

+ func (ag *AvailabilityGroup) UnjoinDatabaseContext(ctx context.Context, name string) error

+ type AvailabilityGroupListener struct

+ DNSName string

+ GroupID string

+ IPAddresses []AvailabilityListenerIP

+ IPConfigurationString string

+ IsConformant bool

+ IsDistributedNetworkName bool

+ ListenerID string

+ Port int

+ type AvailabilityListenerIP struct

+ IPAddress string

+ IsDHCP bool

+ State string

+ SubnetMask string

+ type AvailabilityListenerIPSpec struct

+ IPAddress string

+ SubnetMask string

+ type AvailabilityListenerSpec struct

+ DHCP bool

+ DHCPSubnet string

+ DHCPSubnetMask string

+ DNSName string

+ IPAddresses []AvailabilityListenerIPSpec

+ Port int

+ type AvailabilityReplica struct

+ AvailabilityMode string

+ BackupPriority int

+ ConnectedState string

+ CreateDate time.Time

+ EndpointURL string

+ FailoverMode string

+ GroupID string

+ GroupName string

+ IsLocal bool

+ LastConnectErrorDescription string

+ LastConnectErrorNumber int

+ LastConnectErrorTimestamp time.Time

+ ModifyDate time.Time

+ OperationalState string

+ PrimaryRoleAllowConnections string

+ ReadOnlyRoutingURL string

+ RecoveryHealth string

+ ReplicaID string

+ ReplicaServerName string

+ Role string

+ SecondaryRoleAllowConnections string

+ SeedingMode string

+ SessionTimeout int

+ SynchronizationHealth string

+ func (r *AvailabilityReplica) Drop() error

+ func (r *AvailabilityReplica) DropContext(ctx context.Context) error

+ func (r *AvailabilityReplica) ReadOnlyRoutingList() ([][]string, error)

+ func (r *AvailabilityReplica) ReadOnlyRoutingListContext(ctx context.Context) ([][]string, error)

+ func (r *AvailabilityReplica) SetAvailabilityMode(mode string) error

+ func (r *AvailabilityReplica) SetAvailabilityModeContext(ctx context.Context, mode string) error

+ func (r *AvailabilityReplica) SetBackupPriority(priority int) error

+ func (r *AvailabilityReplica) SetBackupPriorityContext(ctx context.Context, priority int) error

+ func (r *AvailabilityReplica) SetFailoverMode(mode string) error

+ func (r *AvailabilityReplica) SetFailoverModeContext(ctx context.Context, mode string) error

+ func (r *AvailabilityReplica) SetPrimaryRoleAllowConnections(mode string) error

+ func (r *AvailabilityReplica) SetPrimaryRoleAllowConnectionsContext(ctx context.Context, mode string) error

+ func (r *AvailabilityReplica) SetReadOnlyRoutingList(list [][]string) error

+ func (r *AvailabilityReplica) SetReadOnlyRoutingListContext(ctx context.Context, list [][]string) error

+ func (r *AvailabilityReplica) SetReadOnlyRoutingURL(url string) error

+ func (r *AvailabilityReplica) SetReadOnlyRoutingURLContext(ctx context.Context, url string) error

+ func (r *AvailabilityReplica) SetSecondaryRoleAllowConnections(mode string) error

+ func (r *AvailabilityReplica) SetSecondaryRoleAllowConnectionsContext(ctx context.Context, mode string) error

+ func (r *AvailabilityReplica) SetSeedingMode(mode string) error

+ func (r *AvailabilityReplica) SetSeedingModeContext(ctx context.Context, mode string) error

+ func (r *AvailabilityReplica) SetSessionTimeout(seconds int) error

+ func (r *AvailabilityReplica) SetSessionTimeoutContext(ctx context.Context, seconds int) error

+ type AvailabilityReplicaSpec struct

+ AvailabilityMode string

+ BackupPriority int

+ EndpointURL string

+ FailoverMode string

+ PrimaryRoleAllowConnections string

+ ReadOnlyRoutingURL string

+ SecondaryRoleAllowConnections string

+ SeedingMode string

+ ServerName string

+ SessionTimeout int

+ type Certificate struct

+ CertificateID int

+ ExpiryDate time.Time

+ Name string

+ PrincipalID int

+ PvtKeyEncryptionType string

+ StartDate time.Time

+ Subject string

+ Thumbprint []byte

+ func (c *Certificate) Drop() error

+ func (c *Certificate) DropContext(ctx context.Context) error

+ func (c *Certificate) Encoded() ([]byte, error)

+ func (c *Certificate) EncodedContext(ctx context.Context) ([]byte, error)

+ func (c *Certificate) HasPrivateKey() bool

+ type CertificateSpec struct

+ Authorization string

+ EncryptionPassword string

+ ExpiryDate time.Time

+ FromBinary []byte

+ Name string

+ StartDate time.Time

+ Subject string

+ type CreateAvailabilityGroupRequest struct

+ AutomatedBackupPreference string

+ Basic bool

+ ClusterType string

+ Contained bool

+ DBFailover bool

+ DTCSupport bool

+ Databases []string

+ FailureConditionLevel int

+ HealthCheckTimeout int

+ Name string

+ Replicas []AvailabilityReplicaSpec

+ RequiredSynchronizedSecondariesToCommit int

type Database

+ func (d *Database) CertificateByName(name string) (*Certificate, error)

+ func (d *Database) CertificateByNameContext(ctx context.Context, name string) (*Certificate, error)

+ func (d *Database) CertificateSeq(ctx context.Context) iter.Seq2[*Certificate, error]

+ func (d *Database) Certificates() ([]*Certificate, error)

+ func (d *Database) CertificatesContext(ctx context.Context) ([]*Certificate, error)

+ func (d *Database) CreateCertificate(spec CertificateSpec) error

+ func (d *Database) CreateCertificateContext(ctx context.Context, spec CertificateSpec) error

+ func (d *Database) CreateMasterKey(password string) error

+ func (d *Database) CreateMasterKeyContext(ctx context.Context, password string) error

+ func (d *Database) DropDatabaseRole(name string) error

+ func (d *Database) DropDatabaseRoleContext(ctx context.Context, name string) error

+ func (d *Database) DropFunction(schema, name string) error

+ func (d *Database) DropFunctionContext(ctx context.Context, schema, name string) error

+ func (d *Database) DropSequence(schema, name string) error

+ func (d *Database) DropSequenceContext(ctx context.Context, schema, name string) error

+ func (d *Database) DropSynonym(schema, name string) error

+ func (d *Database) DropSynonymContext(ctx context.Context, schema, name string) error

+ func (d *Database) DropTrigger(schema, name string) error

+ func (d *Database) DropTriggerContext(ctx context.Context, schema, name string) error

+ func (d *Database) DropView(schema, name string) error

+ func (d *Database) DropViewContext(ctx context.Context, schema, name string) error

+ func (d *Database) HasMasterKey() (bool, error)

+ func (d *Database) HasMasterKeyContext(ctx context.Context) (bool, error)

+ func (d *Database) RenameObject(schema, oldName, newName string) error

+ func (d *Database) RenameObjectContext(ctx context.Context, schema, oldName, newName string) error

+ func (d *Database) Table(schema, name string) *Table

+ type DatabaseMirroringEndpoint struct

+ ConnectionAuth string

+ EncryptionAlgorithm string

+ IsEncryptionEnabled bool

+ Name string

+ Owner string

+ Port int

+ Role string

+ State string

+ func (e *DatabaseMirroringEndpoint) Drop() error

+ func (e *DatabaseMirroringEndpoint) DropContext(ctx context.Context) error

+ func (e *DatabaseMirroringEndpoint) GrantConnect(login string) error

+ func (e *DatabaseMirroringEndpoint) GrantConnectContext(ctx context.Context, login string) error

+ func (e *DatabaseMirroringEndpoint) Server() *Server

+ func (e *DatabaseMirroringEndpoint) Start() error

+ func (e *DatabaseMirroringEndpoint) StartContext(ctx context.Context) error

+ func (e *DatabaseMirroringEndpoint) Stop() error

+ func (e *DatabaseMirroringEndpoint) StopContext(ctx context.Context) error

+ func (e *DatabaseMirroringEndpoint) URL() string

type DatabaseRole

+ func (r *DatabaseRole) Drop() error

+ func (r *DatabaseRole) DropContext(ctx context.Context) error

+ type EndpointSpec struct

+ Authentication string

+ Encryption string

+ EncryptionAlgorithm string

+ Name string

+ Port int

+ Role string

type ErrorLogEntry

+ Date time.Time

+ ErrorLevel int

+ func (e *ErrorLogEntry) Source() string

+ type ErrorLogFile struct

+ Date string

+ LastWritten time.Time

+ Number int

+ SizeBytes int64

+ type ErrorLogType int

+ const ErrorLogAgent

+ const ErrorLogSQLServer

+ func (t ErrorLogType) String() string

+ type FileSystemEntry struct

+ FullPath string

+ IsDirectory bool

+ LastModified time.Time

+ Name string

+ Size int64

+ type FixedDrive struct

+ FreeSpaceBytes int64

+ Name string

+ Type string

type Server

+ func (s *Server) AvailabilityGroup(name string) *AvailabilityGroup

+ func (s *Server) AvailabilityGroupByName(name string) (*AvailabilityGroup, error)

+ func (s *Server) AvailabilityGroupByNameContext(ctx context.Context, name string) (*AvailabilityGroup, error)

+ func (s *Server) AvailabilityGroupSeq(ctx context.Context) iter.Seq2[*AvailabilityGroup, error]

+ func (s *Server) AvailabilityGroups() ([]*AvailabilityGroup, error)

+ func (s *Server) AvailabilityGroupsContext(ctx context.Context) ([]*AvailabilityGroup, error)

+ func (s *Server) CreateAvailabilityGroup(req CreateAvailabilityGroupRequest) (*AvailabilityGroup, error)

+ func (s *Server) CreateAvailabilityGroupContext(ctx context.Context, req CreateAvailabilityGroupRequest) (*AvailabilityGroup, error)

+ func (s *Server) CreateDatabaseMirroringEndpoint(spec EndpointSpec) (*DatabaseMirroringEndpoint, error)

+ func (s *Server) CreateDatabaseMirroringEndpointContext(ctx context.Context, spec EndpointSpec) (*DatabaseMirroringEndpoint, error)

+ func (s *Server) DatabaseMirroringEndpoint() (*DatabaseMirroringEndpoint, error)

+ func (s *Server) DatabaseMirroringEndpointContext(ctx context.Context) (*DatabaseMirroringEndpoint, error)

+ func (s *Server) DropServerRole(name string) error

+ func (s *Server) DropServerRoleContext(ctx context.Context, name string) error

+ func (s *Server) EnumErrorLogSeq(ctx context.Context, logType ErrorLogType) iter.Seq2[*ErrorLogFile, error]

+ func (s *Server) EnumErrorLogs(logType ErrorLogType) ([]*ErrorLogFile, error)

+ func (s *Server) EnumErrorLogsContext(ctx context.Context, logType ErrorLogType) ([]*ErrorLogFile, error)

+ func (s *Server) EnumFileSystem(path string) ([]*FileSystemEntry, error)

+ func (s *Server) EnumFileSystemContext(ctx context.Context, path string) ([]*FileSystemEntry, error)

+ func (s *Server) FileSystemExists(path string) (exists, isDirectory bool, err error)

+ func (s *Server) FileSystemExistsContext(ctx context.Context, path string) (exists, isDirectory bool, err error)

+ func (s *Server) FixedDrives() ([]*FixedDrive, error)

+ func (s *Server) FixedDrivesContext(ctx context.Context) ([]*FixedDrive, error)

+ func (s *Server) ReadLog(logType ErrorLogType, logNumber int) ([]*ErrorLogEntry, error)

+ func (s *Server) ReadLogContext(ctx context.Context, logType ErrorLogType, logNumber int) ([]*ErrorLogEntry, error)

+ func (s *Server) ReadLogSeq(ctx context.Context, logType ErrorLogType, logNumber int) iter.Seq2[*ErrorLogEntry, error]

+ func (s *Server) RenameDatabase(oldName, newName string, force bool) error

+ func (s *Server) RenameDatabaseContext(ctx context.Context, oldName, newName string, force bool) error

type ServerRole

+ func (r *ServerRole) Drop() error

+ func (r *ServerRole) DropContext(ctx context.Context) error

type Statistic

+ func (st *Statistic) Rename(newName string) error

+ func (st *Statistic) RenameContext(ctx context.Context, newName string) error

type Table

+ func (t *Table) DropConstraint(name string) error

+ func (t *Table) DropConstraintContext(ctx context.Context, name string) error

v0.0.8

Aug 11, 2026

Changes in this version

+ func ColumnPermissionNames() []string

+ type ColumnPermissionEntry struct

+ Column string

+ Grantor string

+ Object string

+ ObjectType string

+ Permission ObjectPermission

+ Principal string

+ PrincipalType string

+ Schema string

+ State PermissionState

type Database

+ func (d *Database) ColumnPermissionSeq(ctx context.Context, schema, name string) iter.Seq2[*ColumnPermissionEntry, error]

+ func (d *Database) ColumnPermissions(schema, name string) ([]*ColumnPermissionEntry, error)

+ func (d *Database) ColumnPermissionsContext(ctx context.Context, schema, name string) ([]*ColumnPermissionEntry, error)

+ func (d *Database) ColumnPermissionsForPrincipal(principal string) ([]*ColumnPermissionEntry, error)

+ func (d *Database) ColumnPermissionsForPrincipalContext(ctx context.Context, principal string) ([]*ColumnPermissionEntry, error)

+ func (d *Database) ColumnPermissionsForPrincipalSeq(ctx context.Context, principal string) iter.Seq2[*ColumnPermissionEntry, error]

+ func (d *Database) DenyColumnPermission(schema, name string, permission ObjectPermission, columns []string, ...) error

+ func (d *Database) DenyColumnPermissionContext(ctx context.Context, schema, name string, permission ObjectPermission, ...) error

+ func (d *Database) DenyColumnPermissionWithOptions(schema, name string, permission ObjectPermission, columns []string, ...) error

+ func (d *Database) DenyColumnPermissionWithOptionsContext(ctx context.Context, schema, name string, permission ObjectPermission, ...) error

+ func (d *Database) DenyDatabasePermissionWithOptions(permission, principal string, opts PermissionOptions) error

+ func (d *Database) DenyDatabasePermissionWithOptionsContext(ctx context.Context, permission, principal string, opts PermissionOptions) error

+ func (d *Database) DenyPermissionWithOptions(schema, name string, permission ObjectPermission, principal string, ...) error

+ func (d *Database) DenyPermissionWithOptionsContext(ctx context.Context, schema, name string, permission ObjectPermission, ...) error

+ func (d *Database) DenySchemaPermissionWithOptions(schemaName string, permission ObjectPermission, principal string, ...) error

+ func (d *Database) DenySchemaPermissionWithOptionsContext(ctx context.Context, schemaName string, permission ObjectPermission, ...) error

+ func (d *Database) EffectiveObjectPermissionSeq(ctx context.Context, schema, name, principal string) iter.Seq2[*EffectivePermission, error]

+ func (d *Database) EffectiveObjectPermissions(schema, name, principal string) ([]*EffectivePermission, error)

+ func (d *Database) EffectiveObjectPermissionsContext(ctx context.Context, schema, name, principal string) ([]*EffectivePermission, error)

+ func (d *Database) EffectivePermissionSeq(ctx context.Context, principal string) iter.Seq2[*EffectivePermission, error]

+ func (d *Database) EffectivePermissions(principal string) ([]*EffectivePermission, error)

+ func (d *Database) EffectivePermissionsContext(ctx context.Context, principal string) ([]*EffectivePermission, error)

+ func (d *Database) EffectiveSchemaPermissionSeq(ctx context.Context, schemaName, principal string) iter.Seq2[*EffectivePermission, error]

+ func (d *Database) EffectiveSchemaPermissions(schemaName, principal string) ([]*EffectivePermission, error)

+ func (d *Database) EffectiveSchemaPermissionsContext(ctx context.Context, schemaName, principal string) ([]*EffectivePermission, error)

+ func (d *Database) FindSecurables(search SecurableSearch) ([]SecurableRef, error)

+ func (d *Database) FindSecurablesContext(ctx context.Context, search SecurableSearch) ([]SecurableRef, error)

+ func (d *Database) GrantColumnPermission(schema, name string, permission ObjectPermission, columns []string, ...) error

+ func (d *Database) GrantColumnPermissionContext(ctx context.Context, schema, name string, permission ObjectPermission, ...) error

+ func (d *Database) GrantColumnPermissionWithOptions(schema, name string, permission ObjectPermission, columns []string, ...) error

+ func (d *Database) GrantColumnPermissionWithOptionsContext(ctx context.Context, schema, name string, permission ObjectPermission, ...) error

+ func (d *Database) GrantDatabasePermissionWithOptions(permission, principal string, opts PermissionOptions) error

+ func (d *Database) GrantDatabasePermissionWithOptionsContext(ctx context.Context, permission, principal string, opts PermissionOptions) error

+ func (d *Database) GrantPermissionWithOptions(schema, name string, permission ObjectPermission, principal string, ...) error

+ func (d *Database) GrantPermissionWithOptionsContext(ctx context.Context, schema, name string, permission ObjectPermission, ...) error

+ func (d *Database) GrantSchemaPermissionWithOptions(schemaName string, permission ObjectPermission, principal string, ...) error

+ func (d *Database) GrantSchemaPermissionWithOptionsContext(ctx context.Context, schemaName string, permission ObjectPermission, ...) error

+ func (d *Database) ObjectColumnSeq(ctx context.Context, schema, name string) iter.Seq2[*Column, error]

+ func (d *Database) ObjectColumns(schema, name string) ([]*Column, error)

+ func (d *Database) ObjectColumnsContext(ctx context.Context, schema, name string) ([]*Column, error)

+ func (d *Database) RevokeColumnPermission(schema, name string, permission ObjectPermission, columns []string, ...) error

+ func (d *Database) RevokeColumnPermissionContext(ctx context.Context, schema, name string, permission ObjectPermission, ...) error

+ func (d *Database) RevokeColumnPermissionWithOptions(schema, name string, permission ObjectPermission, columns []string, ...) error

+ func (d *Database) RevokeColumnPermissionWithOptionsContext(ctx context.Context, schema, name string, permission ObjectPermission, ...) error

+ func (d *Database) RevokeDatabasePermissionWithOptions(permission, principal string, opts PermissionOptions) error

+ func (d *Database) RevokeDatabasePermissionWithOptionsContext(ctx context.Context, permission, principal string, opts PermissionOptions) error

+ func (d *Database) RevokePermissionWithOptions(schema, name string, permission ObjectPermission, principal string, ...) error

+ func (d *Database) RevokePermissionWithOptionsContext(ctx context.Context, schema, name string, permission ObjectPermission, ...) error

+ func (d *Database) RevokeSchemaPermissionWithOptions(schemaName string, permission ObjectPermission, principal string, ...) error

+ func (d *Database) RevokeSchemaPermissionWithOptionsContext(ctx context.Context, schemaName string, permission ObjectPermission, ...) error

+ type EffectivePermission struct

+ Entity string

+ Permission string

+ Subentity string

type JobStep

+ LastRunDate time.Time

+ LastRunElapsed time.Duration

+ type PermissionOptions struct

+ Cascade bool

+ GrantOptionOnly bool

+ WithGrantOption bool

+ type SecurableRef struct

+ Name string

+ Schema string

+ Type string

+ type SecurableSearch struct

+ Limit int

+ Name string

type Server

+ func (s *Server) BackupFileListForSet(device string, fileNumber int) ([]*BackupFile, error)

+ func (s *Server) BackupFileListForSetContext(ctx context.Context, device string, fileNumber int) ([]*BackupFile, error)

+ func (s *Server) DenyServerPermissionWithOptions(permission, principal string, opts PermissionOptions) error

+ func (s *Server) DenyServerPermissionWithOptionsContext(ctx context.Context, permission, principal string, opts PermissionOptions) error

+ func (s *Server) EffectiveServerPermissionSeq(ctx context.Context, login string) iter.Seq2[*EffectivePermission, error]

+ func (s *Server) EffectiveServerPermissions(login string) ([]*EffectivePermission, error)

+ func (s *Server) EffectiveServerPermissionsContext(ctx context.Context, login string) ([]*EffectivePermission, error)

+ func (s *Server) GrantServerPermissionWithOptions(permission, principal string, opts PermissionOptions) error

+ func (s *Server) GrantServerPermissionWithOptionsContext(ctx context.Context, permission, principal string, opts PermissionOptions) error

+ func (s *Server) RevokeServerPermissionWithOptions(permission, principal string, opts PermissionOptions) error

+ func (s *Server) RevokeServerPermissionWithOptionsContext(ctx context.Context, permission, principal string, opts PermissionOptions) error

v0.0.7

Aug 4, 2026

Changes in this version

+ func Scripting(ctx context.Context) bool

type BackupOptions

+ FileGroups []string

+ Files []string

type Database

+ func (d *Database) TableRowCounts() (map[int]int64, error)

+ func (d *Database) TableRowCountsContext(ctx context.Context) (map[int]int64, error)

+ func (d *Database) TableSpaceUsedAll() (map[int]*TableSpaceInfo, error)

+ func (d *Database) TableSpaceUsedAllContext(ctx context.Context) (map[int]*TableSpaceInfo, error)

type IndexType

+ const IndexTypeClusteredColumnStore

+ func (t IndexType) IsColumnStore() bool

type RestoreOptions

+ FileGroups []string

+ FileNumber int

+ Files []string

type Server

+ func (s *Server) Alert(name string) *Alert

+ func (s *Server) Job(name string) *Job

+ func (s *Server) Operator(name string) *Operator

+ func (s *Server) Schedule(name string) *Schedule

v0.0.6

Jul 28, 2026

Changes in this version

+ const RelativeDayDay

+ const RelativeDayFriday

+ const RelativeDayMonday

+ const RelativeDaySaturday

+ const RelativeDaySunday

+ const RelativeDayThursday

+ const RelativeDayTuesday

+ const RelativeDayWednesday

+ const RelativeDayWeekday

+ const RelativeDayWeekendDay

+ const RelativeFirst

+ const RelativeFourth

+ const RelativeLast

+ const RelativeSecond

+ const RelativeThird

+ const WeekdayFriday

+ const WeekdayMonday

+ const WeekdaySaturday

+ const WeekdaySunday

+ const WeekdayThursday

+ const WeekdayTuesday

+ const WeekdayWednesday

+ type AgentStatus struct

+ LastStartupTime time.Time

+ Running bool

+ StatusText string

+ type Alert struct

+ Category string

+ DatabaseName string

+ DelayBetweenResponses time.Duration

+ Enabled bool

+ ErrorNumber int

+ EventDescriptionKeyword string

+ EventSource string

+ ID int

+ IncludeEventDescriptionIn int

+ JobName string

+ LastOccurrence time.Time

+ LastResponse time.Time

+ Name string

+ NotificationMessage string

+ OccurrenceCount int

+ PerformanceCondition string

+ Severity int

+ func (a *Alert) Disable() error

+ func (a *Alert) DisableContext(ctx context.Context) error

+ func (a *Alert) Drop() error

+ func (a *Alert) DropContext(ctx context.Context) error

+ func (a *Alert) Enable() error

+ func (a *Alert) EnableContext(ctx context.Context) error

+ func (a *Alert) IsEventAlert() bool

+ func (a *Alert) NotificationSeq() iter.Seq2[*AlertNotification, error]

+ func (a *Alert) Notifications() ([]*AlertNotification, error)

+ func (a *Alert) NotificationsContext(ctx context.Context) ([]*AlertNotification, error)

+ func (a *Alert) Notify(operatorName string, method NotificationMethod) error

+ func (a *Alert) NotifyContext(ctx context.Context, operatorName string, method NotificationMethod) error

+ func (a *Alert) RemoveNotify(operatorName string) error

+ func (a *Alert) RemoveNotifyContext(ctx context.Context, operatorName string) error

+ func (a *Alert) Rename(newName string) error

+ func (a *Alert) RenameContext(ctx context.Context, newName string) error

+ func (a *Alert) SetCategory(category string) error

+ func (a *Alert) SetCategoryContext(ctx context.Context, category string) error

+ func (a *Alert) SetDatabase(dbName string) error

+ func (a *Alert) SetDatabaseContext(ctx context.Context, dbName string) error

+ func (a *Alert) SetDelay(d time.Duration) error

+ func (a *Alert) SetDelayContext(ctx context.Context, d time.Duration) error

+ func (a *Alert) SetJobResponse(jobName string) error

+ func (a *Alert) SetJobResponseContext(ctx context.Context, jobName string) error

+ func (a *Alert) SetNotificationMessage(msg string) error

+ func (a *Alert) SetNotificationMessageContext(ctx context.Context, msg string) error

+ func (a *Alert) SetTrigger(errorNumber, severity int) error

+ func (a *Alert) SetTriggerContext(ctx context.Context, errorNumber, severity int) error

+ type AlertNotification struct

+ Method NotificationMethod

+ OperatorName string

+ type AlertNotificationRef struct

+ AlertName string

+ Method NotificationMethod

+ type Category struct

+ Class CategoryClass

+ ID int

+ Name string

+ type CategoryClass string

+ const CategoryClassAlert

+ const CategoryClassJob

+ const CategoryClassOperator

type ConnectionOptions

+ ConnMaxIdleTime time.Duration

+ type CreateAlertRequest struct

+ Category string

+ DatabaseName string

+ DelayBetweenResponses time.Duration

+ Enabled bool

+ ErrorNumber int

+ IncludeEventDescriptionIn int

+ Name string

+ NotificationMessage string

+ Severity int

+ type CreateOperatorRequest struct

+ Category string

+ EmailAddress string

+ Enabled bool

+ Name string

+ type CreateScheduleRequest struct

+ ActiveEndDate time.Time

+ ActiveEndTime int

+ ActiveStartDate time.Time

+ ActiveStartTime int

+ Enabled bool

+ FreqInterval int

+ FreqRecurrenceFactor int

+ FreqRelativeInterval int

+ FreqSubdayInterval int

+ FreqSubdayType ScheduleSubdayType

+ FreqType ScheduleFreqType

+ Name string

+ OwnerLoginName string

type Database

+ func (d *Database) DatabaseRoleSeq() iter.Seq2[*DatabaseRole, error]

+ func (d *Database) DatabaseScopedConfigSeq() iter.Seq2[*DatabaseScopedConfig, error]

+ func (d *Database) DependencySeq(schema, name string) iter.Seq2[*Dependency, error]

+ func (d *Database) DependentSeq(schema, name string) iter.Seq2[*Dependency, error]

+ func (d *Database) ExtendedPropertySeq(level ExtendedPropertyLevel) iter.Seq2[*ExtendedProperty, error]

+ func (d *Database) FileGroupSeq() iter.Seq2[*FileGroup, error]

+ func (d *Database) PermissionSeq(schema, name string) iter.Seq2[*PermissionEntry, error]

+ func (d *Database) PermissionsForPrincipalSeq(principal string) iter.Seq2[*PrincipalSecurable, error]

+ func (d *Database) RoleMemberSeq(roleName string) iter.Seq2[*RoleMember, error]

+ func (d *Database) SchemaPermissionSeq(schemaName string) iter.Seq2[*PermissionEntry, error]

+ func (d *Database) SearchSeq(pattern string) iter.Seq2[*SearchResult, error]

+ func (d *Database) TablesBySchemaSeq(schema string) iter.Seq2[*Table, error]

+ func (d *Database) TriggerSeq() iter.Seq2[*Trigger, error]

+ func (d *Database) UserDefinedFunctionSeq() iter.Seq2[*UserDefinedFunction, error]

type Index

+ AllowPageLocks bool

+ AllowRowLocks bool

+ DataCompression string

+ IgnoreDupKey bool

+ IsPadded bool

+ func (idx *Index) EnableContext(ctx context.Context, t *Table) error

+ func (idx *Index) Fragmentation(t *Table, mode string) (*IndexFragmentation, error)

+ func (idx *Index) FragmentationContext(ctx context.Context, t *Table, mode string) (*IndexFragmentation, error)

+ func (idx *Index) RebuildWithOptions(t *Table, fillFactor int, padIndex bool, dataCompression string) error

+ func (idx *Index) RebuildWithOptionsContext(ctx context.Context, t *Table, fillFactor int, padIndex bool, ...) error

+ func (idx *Index) Rename(t *Table, newName string) error

+ func (idx *Index) RenameContext(ctx context.Context, t *Table, newName string) error

+ func (idx *Index) SetIncludedColumns(t *Table, columns []string) error

+ func (idx *Index) SetIncludedColumnsContext(ctx context.Context, t *Table, columns []string) error

+ func (idx *Index) SetLockOptions(t *Table, allowRowLocks, allowPageLocks bool) error

+ func (idx *Index) SetLockOptionsContext(ctx context.Context, t *Table, allowRowLocks, allowPageLocks bool) error

+ func (idx *Index) SetOptions(t *Table, ignoreDupKey, allowRowLocks, allowPageLocks bool) error

+ func (idx *Index) SetOptionsContext(ctx context.Context, t *Table, ...) error

+ func (idx *Index) StorageInfo(t *Table) (*IndexStorageInfo, error)

+ func (idx *Index) StorageInfoContext(ctx context.Context, t *Table) (*IndexStorageInfo, error)

+ func (idx *Index) UpdateStatistics(t *Table) error

+ func (idx *Index) UpdateStatisticsContext(ctx context.Context, t *Table) error

+ type IndexAllocationUnit struct

+ Pages int64

+ Type string

+ UsedKB int64

type IndexFragmentation

+ AvgPageSpaceUsedPct float64

+ type IndexStorageInfo struct

+ Allocations []IndexAllocationUnit

+ AvgRecordSize float64

+ FileGroup string

+ PartitionColumn string

+ PartitionScheme string

+ ReservedKB int64

+ RowCount int64

+ UsedKB int64

type Job

+ DeleteLevel NotifyLevel

+ NotifyEmailOperatorName string

+ NotifyLevelEmail NotifyLevel

+ func (j *Job) AttachSchedule(scheduleName string) error

+ func (j *Job) AttachScheduleContext(ctx context.Context, scheduleName string) error

+ func (j *Job) DetachSchedule(scheduleName string) error

+ func (j *Job) DetachScheduleContext(ctx context.Context, scheduleName string) error

+ func (j *Job) DisableContext(ctx context.Context) error

+ func (j *Job) EnableContext(ctx context.Context) error

+ func (j *Job) HistorySeq(limit int) iter.Seq2[*JobHistoryEntry, error]

+ func (j *Job) Rename(newName string) error

+ func (j *Job) RenameContext(ctx context.Context, newName string) error

+ func (j *Job) ScheduleSeq() iter.Seq2[*Schedule, error]

+ func (j *Job) Schedules() ([]*Schedule, error)

+ func (j *Job) SchedulesContext(ctx context.Context) ([]*Schedule, error)

+ func (j *Job) SetCategory(category string) error

+ func (j *Job) SetCategoryContext(ctx context.Context, category string) error

+ func (j *Job) SetDeleteLevel(level NotifyLevel) error

+ func (j *Job) SetDeleteLevelContext(ctx context.Context, level NotifyLevel) error

+ func (j *Job) SetDescription(desc string) error

+ func (j *Job) SetDescriptionContext(ctx context.Context, desc string) error

+ func (j *Job) SetEmailNotify(operatorName string, level NotifyLevel) error

+ func (j *Job) SetEmailNotifyContext(ctx context.Context, operatorName string, level NotifyLevel) error

+ func (j *Job) SetOwner(loginName string) error

+ func (j *Job) SetOwnerContext(ctx context.Context, loginName string) error

+ func (j *Job) SetStartStep(stepID int) error

+ func (j *Job) SetStartStepContext(ctx context.Context, stepID int) error

+ func (j *Job) StepSeq() iter.Seq2[*JobStep, error]

type JobHistoryEntry

+ JobName string

+ type JobNotificationRef struct

+ JobName string

+ Level NotifyLevel

type JobStep

+ Database string

+ Flags int

+ OnFailStepID int

+ OnSuccessStepID int

+ OutputFileName string

+ func (s *JobStep) Delete() error

+ func (s *JobStep) DeleteContext(ctx context.Context) error

+ func (s *JobStep) Update(req JobStepRequest) error

+ func (s *JobStep) UpdateContext(ctx context.Context, req JobStepRequest) error

type JobStepRequest

+ OnFailStepID int

+ OnSuccessStepID int

+ OutputFileName string

type Login

+ func (l *Login) DropContext(ctx context.Context) error

+ type NotificationMethod int

+ const NotifyMethodEmail

+ const NotifyMethodNetSend

+ const NotifyMethodPager

+ func (m NotificationMethod) String() string

+ type NotifyLevel int

+ const NotifyNever

+ const NotifyOnComplete

+ const NotifyOnFailure

+ const NotifyOnSuccess

+ type Operator struct

+ Category string

+ EmailAddress string

+ Enabled bool

+ ID int

+ LastEmailDate time.Time

+ LastNetSendDate time.Time

+ LastPagerDate time.Time

+ Name string

+ NetSendAddress string

+ PagerAddress string

+ func (o *Operator) Disable() error

+ func (o *Operator) DisableContext(ctx context.Context) error

+ func (o *Operator) Drop() error

+ func (o *Operator) DropContext(ctx context.Context) error

+ func (o *Operator) Enable() error

+ func (o *Operator) EnableContext(ctx context.Context) error

+ func (o *Operator) NotifyingAlertSeq() iter.Seq2[*AlertNotificationRef, error]

+ func (o *Operator) NotifyingAlerts() ([]*AlertNotificationRef, error)

+ func (o *Operator) NotifyingAlertsContext(ctx context.Context) ([]*AlertNotificationRef, error)

+ func (o *Operator) NotifyingJobSeq() iter.Seq2[*JobNotificationRef, error]

+ func (o *Operator) NotifyingJobs() ([]*JobNotificationRef, error)

+ func (o *Operator) NotifyingJobsContext(ctx context.Context) ([]*JobNotificationRef, error)

+ func (o *Operator) Rename(newName string) error

+ func (o *Operator) RenameContext(ctx context.Context, newName string) error

+ func (o *Operator) SetCategory(category string) error

+ func (o *Operator) SetCategoryContext(ctx context.Context, category string) error

+ func (o *Operator) SetEmailAddress(addr string) error

+ func (o *Operator) SetEmailAddressContext(ctx context.Context, addr string) error

+ type Schedule struct

+ ActiveEndDate time.Time

+ ActiveEndTime int

+ ActiveStartDate time.Time

+ ActiveStartTime int

+ CreateDate time.Time

+ Enabled bool

+ FreqInterval int

+ FreqRecurrenceFactor int

+ FreqRelativeInterval int

+ FreqSubdayInterval int

+ FreqSubdayType ScheduleSubdayType

+ FreqType ScheduleFreqType

+ ID int

+ ModifyDate time.Time

+ Name string

+ OwnerLoginName string

+ func (sch *Schedule) Description() string

+ func (sch *Schedule) Disable() error

+ func (sch *Schedule) DisableContext(ctx context.Context) error

+ func (sch *Schedule) Drop() error

+ func (sch *Schedule) DropContext(ctx context.Context) error

+ func (sch *Schedule) Enable() error

+ func (sch *Schedule) EnableContext(ctx context.Context) error

+ func (sch *Schedule) JobSeq() iter.Seq2[*Job, error]

+ func (sch *Schedule) Jobs() ([]*Job, error)

+ func (sch *Schedule) JobsContext(ctx context.Context) ([]*Job, error)

+ func (sch *Schedule) Rename(newName string) error

+ func (sch *Schedule) RenameContext(ctx context.Context, newName string) error

+ func (sch *Schedule) SetActiveRange(startDate, endDate time.Time, startTime, endTime int) error

+ func (sch *Schedule) SetActiveRangeContext(ctx context.Context, startDate, endDate time.Time, startTime, endTime int) error

+ func (sch *Schedule) SetFrequency(f ScheduleFrequency) error

+ func (sch *Schedule) SetFrequencyContext(ctx context.Context, f ScheduleFrequency) error

+ func (sch *Schedule) SetOwner(loginName string) error

+ func (sch *Schedule) SetOwnerContext(ctx context.Context, loginName string) error

+ type ScheduleFreqType int

+ const FreqAutoStart

+ const FreqDaily

+ const FreqMonthly

+ const FreqMonthlyRelative

+ const FreqOnIdle

+ const FreqOnce

+ const FreqWeekly

+ type ScheduleFrequency struct

+ FreqInterval int

+ FreqRecurrenceFactor int

+ FreqRelativeInterval int

+ FreqSubdayInterval int

+ FreqSubdayType ScheduleSubdayType

+ FreqType ScheduleFreqType

+ type ScheduleSubdayType int

+ const SubdayHours

+ const SubdayMinutes

+ const SubdayOnce

+ const SubdaySeconds

type Schema

+ func (s *Schema) DropContext(ctx context.Context) error

type Server

+ func (s *Server) ActiveSessionSeq(includeSystem bool) iter.Seq2[*ActiveSession, error]

+ func (s *Server) AddServerRoleMember(roleName, memberName string) error

+ func (s *Server) AddServerRoleMemberContext(ctx context.Context, roleName, memberName string) error

+ func (s *Server) AgentInfo() (*AgentStatus, error)

+ func (s *Server) AgentInfoContext(ctx context.Context) (*AgentStatus, error)

+ func (s *Server) AlertByName(name string) (*Alert, error)

+ func (s *Server) AlertByNameContext(ctx context.Context, name string) (*Alert, error)

+ func (s *Server) AlertSeq() iter.Seq2[*Alert, error]

+ func (s *Server) Alerts() ([]*Alert, error)

+ func (s *Server) AlertsContext(ctx context.Context) ([]*Alert, error)

+ func (s *Server) BackupHistorySeq(databaseName string) iter.Seq2[*BackupInfo, error]

+ func (s *Server) Categories(class CategoryClass) ([]*Category, error)

+ func (s *Server) CategoriesContext(ctx context.Context, class CategoryClass) ([]*Category, error)

+ func (s *Server) CategorySeq(class CategoryClass) iter.Seq2[*Category, error]

+ func (s *Server) ConfigurationSeq() iter.Seq2[*ConfigurationOption, error]

+ func (s *Server) CreateAlert(req CreateAlertRequest) (*Alert, error)

+ func (s *Server) CreateAlertContext(ctx context.Context, req CreateAlertRequest) (*Alert, error)

+ func (s *Server) CreateCategory(class CategoryClass, name string) error

+ func (s *Server) CreateCategoryContext(ctx context.Context, class CategoryClass, name string) error

+ func (s *Server) CreateOperator(req CreateOperatorRequest) (*Operator, error)

+ func (s *Server) CreateOperatorContext(ctx context.Context, req CreateOperatorRequest) (*Operator, error)

+ func (s *Server) CreateSchedule(req CreateScheduleRequest) (*Schedule, error)

+ func (s *Server) CreateScheduleContext(ctx context.Context, req CreateScheduleRequest) (*Schedule, error)

+ func (s *Server) CurrentLogin() (string, error)

+ func (s *Server) CurrentLoginContext(ctx context.Context) (string, error)

+ func (s *Server) DeleteCategory(class CategoryClass, name string) error

+ func (s *Server) DeleteCategoryContext(ctx context.Context, class CategoryClass, name string) error

+ func (s *Server) EventAlertSeq() iter.Seq2[*Alert, error]

+ func (s *Server) EventAlerts() ([]*Alert, error)

+ func (s *Server) EventAlertsContext(ctx context.Context) ([]*Alert, error)

+ func (s *Server) JobHistory(limit int) ([]*JobHistoryEntry, error)

+ func (s *Server) JobHistoryContext(ctx context.Context, limit int) ([]*JobHistoryEntry, error)

+ func (s *Server) JobHistorySeq(limit int) iter.Seq2[*JobHistoryEntry, error]

+ func (s *Server) LinkedServerSeq() iter.Seq2[*LinkedServer, error]

+ func (s *Server) MailProfileSeq() iter.Seq2[*MailProfile, error]

+ func (s *Server) OperatorByName(name string) (*Operator, error)

+ func (s *Server) OperatorByNameContext(ctx context.Context, name string) (*Operator, error)

+ func (s *Server) OperatorSeq() iter.Seq2[*Operator, error]

+ func (s *Server) Operators() ([]*Operator, error)

+ func (s *Server) OperatorsContext(ctx context.Context) ([]*Operator, error)

+ func (s *Server) ReadErrorLogSeq(logNumber int) iter.Seq2[*ErrorLogEntry, error]

+ func (s *Server) RemoveServerRoleMember(roleName, memberName string) error

+ func (s *Server) RemoveServerRoleMemberContext(ctx context.Context, roleName, memberName string) error

+ func (s *Server) ScheduleByName(name string) (*Schedule, error)

+ func (s *Server) ScheduleByNameContext(ctx context.Context, name string) (*Schedule, error)

+ func (s *Server) ScheduleSeq() iter.Seq2[*Schedule, error]

+ func (s *Server) Schedules() ([]*Schedule, error)

+ func (s *Server) SchedulesContext(ctx context.Context) ([]*Schedule, error)

+ func (s *Server) ServerRoleByName(name string) (*ServerRole, error)

+ func (s *Server) ServerRoleByNameContext(ctx context.Context, name string) (*ServerRole, error)

+ func (s *Server) ServerRoleMemberSeq(roleName string) iter.Seq2[*RoleMember, error]

+ func (s *Server) ServerRoleMembers(roleName string) ([]*RoleMember, error)

+ func (s *Server) ServerRoleMembersContext(ctx context.Context, roleName string) ([]*RoleMember, error)

+ func (s *Server) ServerRoleSeq() iter.Seq2[*ServerRole, error]

type ServerRole

+ CreateDate time.Time

+ ID int

+ ModifyDate time.Time

+ Owner string

+ SID []byte

+ func (r *ServerRole) ChangeOwner(newOwner string) error

+ func (r *ServerRole) ChangeOwnerContext(ctx context.Context, newOwner string) error

+ func (r *ServerRole) Rename(newName string) error

+ func (r *ServerRole) RenameContext(ctx context.Context, newName string) error

type Statistic

+ IsIncremental bool

+ ModificationCounter int64

+ NoRecompute bool

+ func (st *Statistic) ColumnSeq() iter.Seq2[string, error]

+ func (st *Statistic) Columns() ([]string, error)

+ func (st *Statistic) ColumnsContext(ctx context.Context) ([]string, error)

+ func (st *Statistic) DensityVector() ([]*StatisticDensity, error)

+ func (st *Statistic) DensityVectorContext(ctx context.Context) ([]*StatisticDensity, error)

+ func (st *Statistic) DensityVectorSeq() iter.Seq2[*StatisticDensity, error]

+ func (st *Statistic) Header() (*StatisticHeader, error)

+ func (st *Statistic) HeaderContext(ctx context.Context) (*StatisticHeader, error)

+ func (st *Statistic) Histogram() ([]*StatisticHistogramStep, error)

+ func (st *Statistic) HistogramContext(ctx context.Context) ([]*StatisticHistogramStep, error)

+ func (st *Statistic) HistogramSeq() iter.Seq2[*StatisticHistogramStep, error]

+ type StatisticDensity struct

+ AllDensity float64

+ AverageLength float64

+ Columns string

+ type StatisticHeader struct

+ AverageKeyLength float64

+ Density float64

+ FilterExpression string

+ PersistedSamplePercent float64

+ Rows int64

+ RowsSampled int64

+ Steps int

+ StringIndex string

+ UnfilteredRows int64

+ Updated string

+ type StatisticHistogramStep struct

+ AvgRangeRows float64

+ DistinctRangeRows int64

+ EqRows float64

+ RangeHighKey string

+ RangeRows float64

type Table

+ func (t *Table) CheckConstraintSeq() iter.Seq2[*CheckConstraint, error]

+ func (t *Table) CheckWhereSyntax(predicate string) error

+ func (t *Table) CheckWhereSyntaxContext(ctx context.Context, predicate string) error

+ func (t *Table) CountWhere(predicate string) (int64, error)

+ func (t *Table) CountWhereContext(ctx context.Context, predicate string) (int64, error)

+ func (t *Table) FragmentationStatsSeq(mode string) iter.Seq2[*IndexFragmentation, error]

type User

+ func (u *User) AddToRoleContext(ctx context.Context, roleName string) error

+ func (u *User) DropContext(ctx context.Context) error

+ func (u *User) RemoveFromRoleContext(ctx context.Context, roleName string) error

v0.0.5

Jul 20, 2026

Changes in this version

+ func BuildRestoreStatement(opts RestoreOptions) (string, error)

+ func ColumnTypeString(col *Column) string

+ func DatabasePermissionNames() []string

+ func ObjectPermissionNames() []string

+ func SchemaPermissionNames() []string

+ func ServerPermissionNames() []string

type BackupAction

+ const BackupActionDifferential

+ type BackupFile struct

+ FileGroupName string

+ LogicalName string

+ MaxSize int64

+ PhysicalName string

+ Size int64

+ Type string

+ type BackupHeader struct

+ BackupFinish time.Time

+ BackupName string

+ BackupSize int64

+ BackupStart time.Time

+ BackupType BackupAction

+ CompatibilityLevel CompatibilityLevel

+ Compressed bool

+ CompressedSize int64

+ DatabaseName string

+ DatabaseVersion int

+ Description string

+ HasChecksums bool

+ IsCopyOnly bool

+ Position int

+ RecoveryModel string

+ ServerName string

+ SoftwareVersionMajor int

+ type Catalog struct

+ Objects []CatalogObject

+ Schemas []string

+ type CatalogColumn struct

+ DataType DataType

+ IsNullable bool

+ MaxLength int

+ Name string

+ Precision int

+ Scale int

+ type CatalogObject struct

+ Columns []CatalogColumn

+ Name string

+ ObjectID int

+ Schema string

+ Type CatalogObjectType

+ type CatalogObjectType int

+ const CatalogTable

+ const CatalogView

type ColumnEncryptionKey

+ func (cek *ColumnEncryptionKey) DropContext(ctx context.Context) error

type ColumnMasterKey

+ func (cmk *ColumnMasterKey) DropContext(ctx context.Context) error

type CompatibilityLevel

+ const CompatLevel2025

type CreateDatabaseOptions

+ LogFile *DatabaseFileSpec

+ PrimaryFile *DatabaseFileSpec

type Database

+ func (d *Database) Catalog() (*Catalog, error)

+ func (d *Database) CatalogContext(ctx context.Context) (*Catalog, error)

+ func (d *Database) ClearQueryStore() error

+ func (d *Database) ClearQueryStoreContext(ctx context.Context) error

+ func (d *Database) ColumnEncryptionKeySeq() iter.Seq2[*ColumnEncryptionKey, error]

+ func (d *Database) ColumnEncryptionKeysContext(ctx context.Context) ([]*ColumnEncryptionKey, error)

+ func (d *Database) ColumnMasterKeySeq() iter.Seq2[*ColumnMasterKey, error]

+ func (d *Database) ColumnMasterKeysContext(ctx context.Context) ([]*ColumnMasterKey, error)

+ func (d *Database) CreateColumnMasterKeyContext(ctx context.Context, name, keyStoreProvider, keyPath string, ...) error

+ func (d *Database) CreatePartitionFunctionContext(ctx context.Context, req CreatePartitionFunctionRequest) error

+ func (d *Database) CreatePartitionSchemeContext(ctx context.Context, name, functionName string, fileGroups []string) error

+ func (d *Database) CreateSequenceContext(ctx context.Context, req CreateSequenceRequest) error

+ func (d *Database) CreateSynonymContext(ctx context.Context, schema, name, baseObject string) error

+ func (d *Database) DatabaseExtendedPropertiesContext(ctx context.Context) ([]*ExtendedProperty, error)

+ func (d *Database) DatabaseExtendedPropertySeq() iter.Seq2[*ExtendedProperty, error]

+ func (d *Database) DatabaseScopedConfigs() ([]*DatabaseScopedConfig, error)

+ func (d *Database) DatabaseScopedConfigsContext(ctx context.Context) ([]*DatabaseScopedConfig, error)

+ func (d *Database) DenySchemaPermission(schemaName string, permission ObjectPermission, principal string) error

+ func (d *Database) DenySchemaPermissionContext(ctx context.Context, schemaName string, permission ObjectPermission, ...) error

+ func (d *Database) ExtendedPropertiesContext(ctx context.Context, level ExtendedPropertyLevel) ([]*ExtendedProperty, error)

+ func (d *Database) FlushQueryStore() error

+ func (d *Database) FlushQueryStoreContext(ctx context.Context) error

+ func (d *Database) GrantSchemaPermission(schemaName string, permission ObjectPermission, principal string) error

+ func (d *Database) GrantSchemaPermissionContext(ctx context.Context, schemaName string, permission ObjectPermission, ...) error

+ func (d *Database) PartitionFunctionSeq() iter.Seq2[*PartitionFunction, error]

+ func (d *Database) PartitionFunctionsContext(ctx context.Context) ([]*PartitionFunction, error)

+ func (d *Database) PartitionSchemeSeq() iter.Seq2[*PartitionScheme, error]

+ func (d *Database) PartitionSchemesContext(ctx context.Context) ([]*PartitionScheme, error)

+ func (d *Database) PermissionsForPrincipal(principal string) ([]*PrincipalSecurable, error)

+ func (d *Database) PermissionsForPrincipalContext(ctx context.Context, principal string) ([]*PrincipalSecurable, error)

+ func (d *Database) QueryStore() (*QueryStoreInfo, error)

+ func (d *Database) QueryStoreContext(ctx context.Context) (*QueryStoreInfo, error)

+ func (d *Database) RevokeSchemaPermission(schemaName string, permission ObjectPermission, principal string) error

+ func (d *Database) RevokeSchemaPermissionContext(ctx context.Context, schemaName string, permission ObjectPermission, ...) error

+ func (d *Database) RoleByName(name string) (*DatabaseRole, error)

+ func (d *Database) RoleByNameContext(ctx context.Context, name string) (*DatabaseRole, error)

+ func (d *Database) RoleMembers(roleName string) ([]*RoleMember, error)

+ func (d *Database) RoleMembersContext(ctx context.Context, roleName string) ([]*RoleMember, error)

+ func (d *Database) SchemaPermissions(schemaName string) ([]*PermissionEntry, error)

+ func (d *Database) SchemaPermissionsContext(ctx context.Context, schemaName string) ([]*PermissionEntry, error)

+ func (d *Database) SecurityPoliciesContext(ctx context.Context) ([]*SecurityPolicy, error)

+ func (d *Database) SecurityPolicySeq() iter.Seq2[*SecurityPolicy, error]

+ func (d *Database) SetDatabaseScopedConfig(name, value string, forSecondary bool) error

+ func (d *Database) SetDatabaseScopedConfigContext(ctx context.Context, name, value string, forSecondary bool) error

+ func (d *Database) SetOffline() error

+ func (d *Database) SetOfflineContext(ctx context.Context) error

+ func (d *Database) SetOnline() error

+ func (d *Database) SetOnlineContext(ctx context.Context) error

+ func (d *Database) SetQueryStoreOptions(opts QueryStoreOptions) error

+ func (d *Database) SetQueryStoreOptionsContext(ctx context.Context, opts QueryStoreOptions) error

+ func (d *Database) SetUserAccess(mode string) error

+ func (d *Database) SetUserAccessContext(ctx context.Context, mode string) error

+ func (d *Database) SynonymSeq() iter.Seq2[*Synonym, error]

+ func (d *Database) SystemCatalog() (*Catalog, error)

+ func (d *Database) SystemCatalogContext(ctx context.Context) (*Catalog, error)

+ func (d *Database) SystemFunctionSeq() iter.Seq2[*UserDefinedFunction, error]

+ func (d *Database) SystemFunctions() ([]*UserDefinedFunction, error)

+ func (d *Database) SystemFunctionsContext(ctx context.Context) ([]*UserDefinedFunction, error)

+ func (d *Database) SystemStoredProcedureSeq() iter.Seq2[*StoredProcedure, error]

+ func (d *Database) SystemStoredProcedures() ([]*StoredProcedure, error)

+ func (d *Database) SystemStoredProceduresContext(ctx context.Context) ([]*StoredProcedure, error)

+ func (d *Database) SystemViewSeq() iter.Seq2[*View, error]

+ func (d *Database) SystemViews() ([]*View, error)

+ func (d *Database) SystemViewsContext(ctx context.Context) ([]*View, error)

+ func (d *Database) UserByName(name string) (*User, error)

+ func (d *Database) UserByNameContext(ctx context.Context, name string) (*User, error)

type DatabaseOptions

+ IsEncrypted bool

type DatabaseRole

+ CreateDate time.Time

+ ModifyDate time.Time

+ SID []byte

+ func (r *DatabaseRole) ChangeOwner(newOwner string) error

+ func (r *DatabaseRole) ChangeOwnerContext(ctx context.Context, newOwner string) error

+ func (r *DatabaseRole) Rename(newName string) error

+ func (r *DatabaseRole) RenameContext(ctx context.Context, newName string) error

+ type DatabaseScopedConfig struct

+ ID int

+ IsValueDefault bool

+ Name string

+ Value string

+ ValueForSecondary string

+ type DiskVolumeInfo struct

+ AvailableMB float64

+ MountPoint string

+ SamplePath string

+ TotalMB float64

+ VolumeName string

type FileGroup

+ IsReadOnly bool

type LoginDetails

+ BadPasswordTime time.Time

type ObjectPermission

+ const PermAlter

+ const PermReferences

+ const PermTakeOwnership

+ const PermViewChangeTracking

type PartitionFunction

+ func (pf *PartitionFunction) DropContext(ctx context.Context) error

+ func (pf *PartitionFunction) MergeRangeContext(ctx context.Context, value string) error

+ func (pf *PartitionFunction) SplitRangeContext(ctx context.Context, value string) error

type PartitionScheme

+ func (ps *PartitionScheme) DropContext(ctx context.Context) error

type PermissionEntry

+ Grantor string

+ type PrincipalSecurable struct

+ Name string

+ Permission string

+ Schema string

+ SecurableType string

+ State string

+ type ProcessorInfo struct

+ CPUCount int

+ CPUNUMANode []int

+ HyperthreadRatio int

+ NUMANodeCount int

+ type QueryStoreInfo struct

+ ActualState string

+ CaptureMode string

+ CapturePolicyCompileCPUMs int64

+ CapturePolicyExecCPUMs int64

+ CapturePolicyExecCount int

+ CapturePolicyStaleHours int

+ CurrentStorageMB int64

+ DesiredState string

+ FlushIntervalSec int

+ IntervalMinutes int

+ MaxPlansPerQuery int

+ MaxStorageMB int64

+ ReadOnlyReason int

+ SizeCleanupMode string

+ StaleThresholdDays int

+ WaitStatsCaptureMode string

+ type QueryStoreOptions struct

+ CaptureMode string

+ CapturePolicyCompileCPUMs int64

+ CapturePolicyExecCPUMs int64

+ CapturePolicyExecCount int

+ CapturePolicyStaleHours int

+ DesiredState string

+ FlushIntervalSec int

+ IntervalMinutes int

+ MaxPlansPerQuery int

+ MaxStorageMB int64

+ SizeCleanupMode string

+ StaleThresholdDays int

+ WaitStatsCaptureMode string

type RestoreOptions

+ Progress func(pct int, message string)

+ type RoleMember struct

+ Name string

+ Type string

type Schema

+ func (s *Schema) ObjectCount() (int, error)

+ func (s *Schema) ObjectCountContext(ctx context.Context) (int, error)

type SecurityPolicy

+ func (p *SecurityPolicy) DisableContext(ctx context.Context) error

+ func (p *SecurityPolicy) DropContext(ctx context.Context) error

+ func (p *SecurityPolicy) EnableContext(ctx context.Context) error

type Sequence

+ func (seq *Sequence) DropContext(ctx context.Context) error

+ func (seq *Sequence) NextValueContext(ctx context.Context) (int64, error)

+ func (seq *Sequence) RestartContext(ctx context.Context, value int64) error

type Server

+ func (s *Server) BackupFileList(device string) ([]*BackupFile, error)

+ func (s *Server) BackupFileListContext(ctx context.Context, device string) ([]*BackupFile, error)

+ func (s *Server) BackupFileSeq(device string) iter.Seq2[*BackupFile, error]

+ func (s *Server) BackupHeaderSeq(device string) iter.Seq2[*BackupHeader, error]

+ func (s *Server) BackupHeaders(device string) ([]*BackupHeader, error)

+ func (s *Server) BackupHeadersContext(ctx context.Context, device string) ([]*BackupHeader, error)

+ func (s *Server) Database(name string) *Database

+ func (s *Server) DiskVolumeSeq() iter.Seq2[DiskVolumeInfo, error]

+ func (s *Server) DiskVolumes() ([]DiskVolumeInfo, error)

+ func (s *Server) DiskVolumesContext(ctx context.Context) ([]DiskVolumeInfo, error)

+ func (s *Server) Login(name string) *Login

+ func (s *Server) ProcessorInfo() (*ProcessorInfo, error)

+ func (s *Server) ProcessorInfoContext(ctx context.Context) (*ProcessorInfo, error)

+ func (s *Server) VerifyBackup(device string) error

+ func (s *Server) VerifyBackupContext(ctx context.Context, device string) error

type ServerInfo

+ EngineEdition int

+ IsSingleUser bool

type SpaceInfo

+ AvailLogMB float64

type Synonym

+ func (syn *Synonym) DropContext(ctx context.Context) error

type Table

+ func (t *Table) Detail() (*TableDetail, error)

+ func (t *Table) DetailContext(ctx context.Context) (*TableDetail, error)

+ func (t *Table) PartitionSeq() iter.Seq2[*PartitionInfo, error]

+ func (t *Table) PartitionsContext(ctx context.Context) ([]*PartitionInfo, error)

+ func (t *Table) SpaceUsed() (*TableSpaceInfo, error)

+ func (t *Table) SpaceUsedContext(ctx context.Context) (*TableSpaceInfo, error)

+ type TableDetail struct

+ DataSpace string

+ Durability string

+ IsReplicated bool

+ IsTrackedByCDC bool

+ LedgerType string

+ LockEscalation string

+ PrimaryKeyName string

+ SchemaOwner string

+ TemporalType string

+ UsesAnsiNulls bool

+ type TableSpaceInfo struct

+ DataKB int64

+ FileGroup string

+ IndexKB int64

+ LOBKB int64

+ ReservedKB int64

+ UnusedKB int64

type User

+ LoginDisabled bool

+ LoginName string

+ SID []byte

+ func (u *User) Rename(newName string) error

+ func (u *User) RenameContext(ctx context.Context, newName string) error

+ func (u *User) SetDefaultSchema(schemaName string) error

+ func (u *User) SetDefaultSchemaContext(ctx context.Context, schemaName string) error

+ func (u *User) SetLogin(loginName string) error

+ func (u *User) SetLoginContext(ctx context.Context, loginName string) error

v0.0.4

Jul 12, 2026

Changes in this version

+ func BuildBackupStatement(opts BackupOptions) (string, error)

+ func IsRetryable(err error) bool

+ func ParseServerAddress(server string) (host, instance string, port int)

+ func QuoteLiteral(s string) string

+ func QuoteName(name string) string

+ func SliceRows(rows [][]any) iter.Seq2[[]any, error]

type BackupOptions

+ Progress func(pct int, message string)

+ type BulkCopy struct

+ Columns []string

+ Options BulkOptions

+ Schema string

+ Table string

+ type BulkOptions struct

+ CheckConstraints bool

+ FireTriggers bool

+ KeepNulls bool

+ KilobytesPerBatch int

+ Order []string

+ RowsPerBatch int

+ TableLock bool

+ type ChangeTrackingInfo struct

+ AutoCleanup bool

+ Enabled bool

+ RetentionPeriod int

+ RetentionUnit string

type Column

+ IsPrimaryKey bool

type ConnectionOptions

+ AccessTokenProvider func(ctx context.Context) (string, error)

+ Kerberos KerberosOptions

+ ServerSPN string

+ SessionInitSQL string

+ type Credential struct

+ CreateDate time.Time

+ Identity string

+ ModifyDate time.Time

+ Name string

type Database

+ func (d *Database) ActualPlan(sql string) (*ExecutionPlan, error)

+ func (d *Database) ActualPlanContext(ctx context.Context, sqlText string) (*ExecutionPlan, error)

+ func (d *Database) AddExtendedPropertyContext(ctx context.Context, name, value string, level ExtendedPropertyLevel) error

+ func (d *Database) AddFile(spec DatabaseFileSpec) error

+ func (d *Database) AddFileContext(ctx context.Context, spec DatabaseFileSpec) error

+ func (d *Database) AddFileGroup(name string) error

+ func (d *Database) AddFileGroupContext(ctx context.Context, name string) error

+ func (d *Database) AlterFile(name string, m FileModify) error

+ func (d *Database) AlterFileContext(ctx context.Context, name string, m FileModify) error

+ func (d *Database) BulkInsert(bc BulkCopy, rows iter.Seq2[[]any, error]) (int64, error)

+ func (d *Database) BulkInsertContext(ctx context.Context, bc BulkCopy, rows iter.Seq2[[]any, error]) (int64, error)

+ func (d *Database) ChangeTracking() (*ChangeTrackingInfo, error)

+ func (d *Database) ChangeTrackingContext(ctx context.Context) (*ChangeTrackingInfo, error)

+ func (d *Database) DatabasePermissionSeq() iter.Seq2[*DatabasePermissionEntry, error]

+ func (d *Database) DatabasePermissions() ([]*DatabasePermissionEntry, error)

+ func (d *Database) DatabasePermissionsContext(ctx context.Context) ([]*DatabasePermissionEntry, error)

+ func (d *Database) DenyDatabasePermission(permission, principal string) error

+ func (d *Database) DenyDatabasePermissionContext(ctx context.Context, permission, principal string) error

+ func (d *Database) DenyPermission(schema, name string, permission ObjectPermission, principal string) error

+ func (d *Database) DenyPermissionContext(ctx context.Context, schema, name string, permission ObjectPermission, ...) error

+ func (d *Database) Dependencies(schema, name string) ([]*Dependency, error)

+ func (d *Database) DependenciesContext(ctx context.Context, schema, name string) ([]*Dependency, error)

+ func (d *Database) Dependents(schema, name string) ([]*Dependency, error)

+ func (d *Database) DependentsContext(ctx context.Context, schema, name string) ([]*Dependency, error)

+ func (d *Database) DropExtendedPropertyContext(ctx context.Context, name string, level ExtendedPropertyLevel) error

+ func (d *Database) EstimatedPlan(sql string) (*ExecutionPlan, error)

+ func (d *Database) EstimatedPlanContext(ctx context.Context, sqlText string) (*ExecutionPlan, error)

+ func (d *Database) ExecProc(schema, name string, params ...ProcParam) (ProcResult, error)

+ func (d *Database) ExecProcContext(ctx context.Context, schema, name string, params ...ProcParam) (ProcResult, error)

+ func (d *Database) FileSeq() iter.Seq2[*DatabaseFileInfo, error]

+ func (d *Database) Files() ([]*DatabaseFileInfo, error)

+ func (d *Database) FilesContext(ctx context.Context) ([]*DatabaseFileInfo, error)

+ func (d *Database) GrantDatabasePermission(permission, principal string) error

+ func (d *Database) GrantDatabasePermissionContext(ctx context.Context, permission, principal string) error

+ func (d *Database) GrantPermission(schema, name string, permission ObjectPermission, principal string) error

+ func (d *Database) GrantPermissionContext(ctx context.Context, schema, name string, permission ObjectPermission, ...) error

+ func (d *Database) IsSystem() bool

+ func (d *Database) Options() (*DatabaseOptions, error)

+ func (d *Database) OptionsContext(ctx context.Context) (*DatabaseOptions, error)

+ func (d *Database) Permissions(schema, name string) ([]*PermissionEntry, error)

+ func (d *Database) PermissionsContext(ctx context.Context, schema, name string) ([]*PermissionEntry, error)

+ func (d *Database) RemoveFile(name string) error

+ func (d *Database) RemoveFileContext(ctx context.Context, name string) error

+ func (d *Database) RemoveFileGroup(name string) error

+ func (d *Database) RemoveFileGroupContext(ctx context.Context, name string) error

+ func (d *Database) RevokeDatabasePermission(permission, principal string) error

+ func (d *Database) RevokeDatabasePermissionContext(ctx context.Context, permission, principal string) error

+ func (d *Database) RevokePermission(schema, name string, permission ObjectPermission, principal string) error

+ func (d *Database) RevokePermissionContext(ctx context.Context, schema, name string, permission ObjectPermission, ...) error

+ func (d *Database) Search(pattern string) ([]*SearchResult, error)

+ func (d *Database) SearchContext(ctx context.Context, pattern string) ([]*SearchResult, error)

+ func (d *Database) SequencesContext(ctx context.Context) ([]*Sequence, error)

+ func (d *Database) SetChangeTracking(info ChangeTrackingInfo) error

+ func (d *Database) SetChangeTrackingContext(ctx context.Context, info ChangeTrackingInfo) error

+ func (d *Database) SetDatabaseOption(opt DatabaseOption, value string) error

+ func (d *Database) SetDatabaseOptionContext(ctx context.Context, opt DatabaseOption, value string) error

+ func (d *Database) SetDefaultFileGroup(name string) error

+ func (d *Database) SetDefaultFileGroupContext(ctx context.Context, name string) error

+ func (d *Database) SetExtendedProperty(name, value string, level ExtendedPropertyLevel) error

+ func (d *Database) SetExtendedPropertyContext(ctx context.Context, name, value string, level ExtendedPropertyLevel) error

+ func (d *Database) SetFileGroupReadOnly(name string, readOnly bool) error

+ func (d *Database) SetFileGroupReadOnlyContext(ctx context.Context, name string, readOnly bool) error

+ func (d *Database) SetOwner(principal string) error

+ func (d *Database) SetOwnerContext(ctx context.Context, principal string) error

+ func (d *Database) SetTableChangeTracking(schema, name string, enable, trackColumns bool) error

+ func (d *Database) SetTableChangeTrackingContext(ctx context.Context, schema, name string, enable, trackColumns bool) error

+ func (d *Database) SynonymsContext(ctx context.Context) ([]*Synonym, error)

+ func (d *Database) TableChangeTracking() ([]*TableChangeTracking, error)

+ func (d *Database) TableChangeTrackingContext(ctx context.Context) ([]*TableChangeTracking, error)

+ func (d *Database) TableChangeTrackingSeq() iter.Seq2[*TableChangeTracking, error]

+ type DatabaseFileInfo struct

+ FileGroup string

+ FileID int

+ GrowthKB int64

+ GrowthPercent int

+ IsPercentGrowth bool

+ MaxSizeKB int64

+ Name string

+ PhysicalName string

+ SizeKB int64

+ State string

+ Type string

+ type DatabaseFileSpec struct

+ FileGroup string

+ GrowthKB int64

+ GrowthPercent int

+ MaxSizeKB int64

+ Name string

+ Path string

+ SizeKB int64

+ Type string

+ type DatabaseOption string

+ const DBOptANSINullDefault

+ const DBOptANSINulls

+ const DBOptANSIPadding

+ const DBOptANSIWarnings

+ const DBOptArithAbort

+ const DBOptAutoClose

+ const DBOptAutoCreateStatistics

+ const DBOptAutoShrink

+ const DBOptAutoUpdateStatistics

+ const DBOptAutoUpdateStatisticsAsync

+ const DBOptConcatNullYieldsNull

+ const DBOptContainment

+ const DBOptCursorCloseOnCommit

+ const DBOptCursorDefault

+ const DBOptNumericRoundAbort

+ const DBOptPageVerify

+ const DBOptQuotedIdentifier

+ const DBOptReadCommittedSnapshot

+ const DBOptRecursiveTriggers

+ const DBOptSnapshotIsolation

+ const DBOptTrustworthy

+ type DatabaseOptions struct

+ ANSINullDefault bool

+ ANSINulls bool

+ ANSIPadding bool

+ ANSIWarnings bool

+ ArithAbort bool

+ AutoClose bool

+ AutoCreateStats bool

+ AutoShrink bool

+ AutoUpdateStats bool

+ AutoUpdateStatsAsync bool

+ ConcatNullYieldsNull bool

+ Containment string

+ CursorCloseOnCommit bool

+ DefaultCursor string

+ IsBrokerEnabled bool

+ IsTrustworthy bool

+ NumericRoundAbort bool

+ Owner string

+ PageVerify string

+ QuotedIdentifier bool

+ ReadCommittedSnapshot bool

+ RecursiveTriggers bool

+ SnapshotIsolation string

+ UserAccess string

+ type DatabasePermissionEntry struct

+ Grantor string

+ Permission string

+ Principal string

+ PrincipalType string

+ State string

+ type Dependency struct

+ IsSchemaBound bool

+ Name string

+ Schema string

+ TypeDesc string

+ type ExecutionPlan struct

+ XML string

+ type FileModify struct

+ GrowthKB int64

+ GrowthPercent int

+ MaxSizeKB int64

+ NewName string

+ SizeKB int64

+ type KerberosOptions struct

+ ConfigFile string

+ CredCacheFile string

+ DNSLookupKDC *bool

+ KeytabFile string

+ Realm string

+ UDPPreferenceLimit int

+ type Language struct

+ Alias string

+ LangID int

+ Name string

type Login

+ func (l *Login) ChangePasswordWithOptions(newPassword string, mustChange, unlock bool) error

+ func (l *Login) ChangePasswordWithOptionsContext(ctx context.Context, newPassword string, mustChange, unlock bool) error

+ func (l *Login) Details() (*LoginDetails, error)

+ func (l *Login) DetailsContext(ctx context.Context) (*LoginDetails, error)

+ func (l *Login) MapCredential(credential string) error

+ func (l *Login) MapCredentialContext(ctx context.Context, credential string) error

+ func (l *Login) MapToDatabase(dbName, userName, defaultSchema string) error

+ func (l *Login) MapToDatabaseContext(ctx context.Context, dbName, userName, defaultSchema string) error

+ func (l *Login) Rename(newName string) error

+ func (l *Login) RenameContext(ctx context.Context, newName string) error

+ func (l *Login) SetDefaultDatabase(name string) error

+ func (l *Login) SetDefaultDatabaseContext(ctx context.Context, name string) error

+ func (l *Login) SetDefaultLanguage(lang string) error

+ func (l *Login) SetDefaultLanguageContext(ctx context.Context, lang string) error

+ func (l *Login) SetPasswordPolicy(checkPolicy, checkExpiration bool) error

+ func (l *Login) SetPasswordPolicyContext(ctx context.Context, checkPolicy, checkExpiration bool) error

+ func (l *Login) UnmapCredential(credential string) error

+ func (l *Login) UnmapCredentialContext(ctx context.Context, credential string) error

+ func (l *Login) UnmapFromDatabase(dbName string) error

+ func (l *Login) UnmapFromDatabaseContext(ctx context.Context, dbName string) error

+ func (l *Login) UserMappingSeq() iter.Seq2[*LoginUserMapping, error]

+ func (l *Login) UserMappings() ([]*LoginUserMapping, error)

+ func (l *Login) UserMappingsContext(ctx context.Context) ([]*LoginUserMapping, error)

+ type LoginDetails struct

+ BadPasswordCount int

+ ConnectSQLState string

+ CredentialName string

+ DefaultLanguage string

+ IsExpirationChecked bool

+ IsExpired bool

+ IsLocked bool

+ IsPolicyChecked bool

+ LastLogin time.Time

+ MustChangePassword bool

+ PasswordLastSet time.Time

+ type LoginUserMapping struct

+ Database string

+ DefaultSchema string

+ Roles []string

+ User string

+ type PermissionEntry struct

+ Permission ObjectPermission

+ Principal string

+ PrincipalType string

+ State PermissionState

+ type ProcParam struct

+ func In(name string, value any) ProcParam

+ func InOut(name string, dest any) ProcParam

+ func Out(name string, dest any) ProcParam

+ type ProcResult struct

+ ReturnStatus int32

+ type SQLError struct

+ All []SQLError

+ Class uint8

+ LineNo int32

+ Message string

+ Number int32

+ ProcName string

+ ServerName string

+ State uint8

+ func AsSQLError(err error) (*SQLError, bool)

+ func (e *SQLError) Error() string

+ func (e *SQLError) Header() string

+ func (e *SQLError) IsError() bool

+ type ScriptCollector struct

+ Statements []string

+ func WithScript(ctx context.Context) (context.Context, *ScriptCollector)

+ type SearchResult struct

+ Name string

+ Schema string

+ TypeDesc string

type Server

+ func (s *Server) CredentialSeq() iter.Seq2[*Credential, error]

+ func (s *Server) Credentials() ([]*Credential, error)

+ func (s *Server) CredentialsContext(ctx context.Context) ([]*Credential, error)

+ func (s *Server) CurrentDatabase() (string, error)

+ func (s *Server) CurrentDatabaseContext(ctx context.Context) (string, error)

+ func (s *Server) DenyServerPermission(permission, principal string) error

+ func (s *Server) DenyServerPermissionContext(ctx context.Context, permission, principal string) error

+ func (s *Server) GrantServerPermission(permission, principal string) error

+ func (s *Server) GrantServerPermissionContext(ctx context.Context, permission, principal string) error

+ func (s *Server) LanguageSeq() iter.Seq2[*Language, error]

+ func (s *Server) Languages() ([]*Language, error)

+ func (s *Server) LanguagesContext(ctx context.Context) ([]*Language, error)

+ func (s *Server) LoginByName(name string) (*Login, error)

+ func (s *Server) LoginByNameContext(ctx context.Context, name string) (*Login, error)

+ func (s *Server) MemoryStats() (*ServerMemoryStats, error)

+ func (s *Server) MemoryStatsContext(ctx context.Context) (*ServerMemoryStats, error)

+ func (s *Server) RevokeServerPermission(permission, principal string) error

+ func (s *Server) RevokeServerPermissionContext(ctx context.Context, permission, principal string) error

+ func (s *Server) SecurityInfo() (*ServerSecurityInfo, error)

+ func (s *Server) SecurityInfoContext(ctx context.Context) (*ServerSecurityInfo, error)

+ func (s *Server) ServerPermissionSeq() iter.Seq2[*ServerPermissionEntry, error]

+ func (s *Server) ServerPermissions() ([]*ServerPermissionEntry, error)

+ func (s *Server) ServerPermissionsContext(ctx context.Context) ([]*ServerPermissionEntry, error)

+ type ServerMemoryStats struct

+ AvailableMemoryMB int64

+ PhysicalMemoryMB int64

+ TargetServerMemoryMB int64

+ TotalServerMemoryMB int64

+ type ServerPermissionEntry struct

+ Grantor string

+ Permission string

+ Principal string

+ PrincipalType string

+ State string

+ type ServerSecurityInfo struct

+ AuthenticationMode string

type SpaceInfo

+ UnallocatedMB float64

type Table

+ func (t *Table) AddColumn(col ColumnDefinition) error

+ func (t *Table) AddColumnContext(ctx context.Context, col ColumnDefinition) error

+ func (t *Table) AlterColumn(col ColumnDefinition) error

+ func (t *Table) AlterColumnContext(ctx context.Context, col ColumnDefinition) error

+ func (t *Table) DropColumn(name string) error

+ func (t *Table) DropColumnContext(ctx context.Context, name string) error

+ func (t *Table) TriggerSeq() iter.Seq2[*Trigger, error]

+ func (t *Table) Triggers() ([]*Trigger, error)

+ func (t *Table) TriggersContext(ctx context.Context) ([]*Trigger, error)

+ type TableChangeTracking struct

+ Enabled bool

+ Name string

+ Schema string

+ TrackColumnsUpdated bool

v0.0.3

Jun 29, 2026

v0.0.2

Jun 25, 2026

v0.0.1

Jun 23, 2026

Changes in this version

+ type ActiveSession struct

+ BlockingSessionID int

+ CPUTime int64

+ CommandText string

+ DatabaseName string

+ HostName string

+ LastRequestStart string

+ LoginName string

+ MemoryUsage int64

+ ProgramName string

+ SessionID int

+ Status string

+ TotalElapsedMS int64

+ WaitTimeMS int64

+ WaitType string

+ type AuthMethod int

+ const AuthEntraAzCLI

+ const AuthEntraAzureDeveloperCLI

+ const AuthEntraAzurePipelines

+ const AuthEntraDefault

+ const AuthEntraDeviceCode

+ const AuthEntraIntegrated

+ const AuthEntraInteractive

+ const AuthEntraMSI

+ const AuthEntraOnBehalfOf

+ const AuthEntraPassword

+ const AuthEntraServicePrincipal

+ const AuthEntraServicePrincipalAccessToken

+ const AuthSQLServer

+ const AuthWindows

+ type BackupAction string

+ const BackupActionDatabase

+ const BackupActionFiles

+ const BackupActionLog

+ type BackupInfo struct

+ BackupFinish time.Time

+ BackupSetName string

+ BackupSize int64

+ BackupStart time.Time

+ BackupType BackupAction

+ CompatibilityLevel CompatibilityLevel

+ DatabaseName string

+ DatabaseVersion int

+ Description string

+ DeviceName string

+ ServerName string

+ UserName string

+ type BackupOptions struct

+ Action BackupAction

+ BackupSetName string

+ Checksum bool

+ Compression *bool

+ CopyOnly bool

+ Database string

+ Description string

+ Devices []string

+ Format bool

+ Init bool

+ MediaDescription string

+ Stats int

+ type CheckConstraint struct

+ Column string

+ Definition string

+ IsDisabled bool

+ Name string

+ type Column struct

+ Collation string

+ ComputedText string

+ DataType DataType

+ DefaultValue *ColumnDefault

+ IdentityIncrement int64

+ IdentitySeed int64

+ IsComputed bool

+ IsIdentity bool

+ IsNullable bool

+ IsRowGUID bool

+ MaxLength int

+ Name string

+ OrdinalPosition int

+ Precision int

+ Scale int

+ type ColumnDefault struct

+ Definition string

+ Name string

+ type ColumnDefinition struct

+ DataType DataType

+ DefaultValue string

+ IdentityIncr int64

+ IdentitySeed int64

+ IsIdentity bool

+ IsNullable bool

+ IsPrimaryKey bool

+ MaxLength int

+ Name string

+ Precision int

+ Scale int

+ type ColumnEncryptionKey struct

+ EncryptionAlgorithm string

+ ID int

+ MasterKeyName string

+ Name string

+ func (cek *ColumnEncryptionKey) Drop() error

+ type ColumnMasterKey struct

+ AllowEnclaveComputations bool

+ ID int

+ KeyPath string

+ KeyStoreProviderName string

+ Name string

+ func (cmk *ColumnMasterKey) Drop() error

+ type CompatibilityLevel int

+ const CompatLevel2008

+ const CompatLevel2012

+ const CompatLevel2014

+ const CompatLevel2016

+ const CompatLevel2017

+ const CompatLevel2019

+ const CompatLevel2022

+ type ConfigurationOption struct

+ ConfigID int

+ Description string

+ IsAdvanced bool

+ IsDynamic bool

+ Maximum int64

+ Minimum int64

+ Name string

+ Value int64

+ ValueInUse int64

+ func (c *ConfigurationOption) SetValue(value int64) error

+ func (c *ConfigurationOption) SetValueContext(ctx context.Context, value int64) error

+ type ConnectionOptions struct

+ AccessToken string

+ ApplicationClientID string

+ ApplicationName string

+ Auth AuthMethod

+ ClientCertPassword string

+ ClientCertPath string

+ ClientID string

+ ConnMaxLifetime time.Duration

+ ConnectTimeout time.Duration

+ Database string

+ DisableInstanceDiscovery bool

+ Encrypt string

+ HostNameInCertificate string

+ MaxIdleConns int

+ MaxOpenConns int

+ Password string

+ SendCertificateChain bool

+ Server string

+ TenantID string

+ TokenFilePath string

+ TrustServerCertificate bool

+ User string

+ type CreateDatabaseOptions struct

+ Collation string

+ CompatLevel CompatibilityLevel

+ RecoveryModel RecoveryModel

+ type CreateIndexRequest struct

+ FillFactor int

+ FilterDefinition string

+ IncludedColumns []string

+ IsUnique bool

+ KeyColumns []IndexColumnDef

+ Name string

+ Online bool

+ SortInTempDB bool

+ Type IndexType

+ type CreateJobRequest struct

+ Category string

+ Description string

+ Enabled bool

+ Name string

+ OwnerLogin string

+ type CreateLoginOptions struct

+ DefaultDatabase string

+ MustChange bool

+ type CreatePartitionFunctionRequest struct

+ Boundaries []string

+ InputType DataType

+ IsRight bool

+ Name string

+ type CreateSequenceRequest struct

+ Cache *int

+ Cycle bool

+ DataType DataType

+ Increment int64

+ MaxValue *int64

+ MinValue *int64

+ Name string

+ Schema string

+ StartValue int64

+ type CreateTableRequest struct

+ Columns []ColumnDefinition

+ Name string

+ Schema string

+ type DataType string

+ const DataTypeBigInt

+ const DataTypeBinary

+ const DataTypeBit

+ const DataTypeChar

+ const DataTypeDate

+ const DataTypeDatetime

+ const DataTypeDatetime2

+ const DataTypeDatetimeOffset

+ const DataTypeDecimal

+ const DataTypeFloat

+ const DataTypeGeography

+ const DataTypeGeometry

+ const DataTypeHierarchyID

+ const DataTypeImage

+ const DataTypeInt

+ const DataTypeMoney

+ const DataTypeNChar

+ const DataTypeNText

+ const DataTypeNVarChar

+ const DataTypeNumeric

+ const DataTypeReal

+ const DataTypeRowVersion

+ const DataTypeSQLVariant

+ const DataTypeSmallDatetime

+ const DataTypeSmallInt

+ const DataTypeSmallMoney

+ const DataTypeText

+ const DataTypeTime

+ const DataTypeTinyInt

+ const DataTypeUniqueIdentifier

+ const DataTypeVarBinary

+ const DataTypeVarChar

+ const DataTypeXML

+ type Database struct

+ func (d *Database) AddExtendedProperty(name, value string, level ExtendedPropertyLevel) error

+ func (d *Database) AddRoleMember(roleName, memberName string) error

+ func (d *Database) AddRoleMemberContext(ctx context.Context, roleName, memberName string) error

+ func (d *Database) Collation() string

+ func (d *Database) ColumnEncryptionKeys() ([]*ColumnEncryptionKey, error)

+ func (d *Database) ColumnMasterKeys() ([]*ColumnMasterKey, error)

+ func (d *Database) CompatibilityLevel() CompatibilityLevel

+ func (d *Database) CreateColumnMasterKey(name, keyStoreProvider, keyPath string, enclaveComputations bool) error

+ func (d *Database) CreateDate() time.Time

+ func (d *Database) CreatePartitionFunction(req CreatePartitionFunctionRequest) error

+ func (d *Database) CreatePartitionScheme(name, functionName string, fileGroups []string) error

+ func (d *Database) CreateSchema(name, owner string) error

+ func (d *Database) CreateSchemaContext(ctx context.Context, name, owner string) error

+ func (d *Database) CreateSequence(req CreateSequenceRequest) error

+ func (d *Database) CreateStoredProcedure(schema, name, body string) error

+ func (d *Database) CreateStoredProcedureContext(ctx context.Context, schema, name, body string) error

+ func (d *Database) CreateSynonym(schema, name, baseObject string) error

+ func (d *Database) CreateTable(req CreateTableRequest) error

+ func (d *Database) CreateTableContext(ctx context.Context, req CreateTableRequest) error

+ func (d *Database) CreateUser(userName, loginName, defaultSchema string) error

+ func (d *Database) CreateUserContext(ctx context.Context, userName, loginName, defaultSchema string) error

+ func (d *Database) DatabaseExtendedProperties() ([]*ExtendedProperty, error)

+ func (d *Database) DatabaseRoles() ([]*DatabaseRole, error)

+ func (d *Database) DatabaseRolesContext(ctx context.Context) ([]*DatabaseRole, error)

+ func (d *Database) DropExtendedProperty(name string, level ExtendedPropertyLevel) error

+ func (d *Database) DropSchema(name string) error

+ func (d *Database) DropSchemaContext(ctx context.Context, name string) error

+ func (d *Database) DropStoredProcedure(schema, name string) error

+ func (d *Database) DropStoredProcedureContext(ctx context.Context, schema, name string) error

+ func (d *Database) DropTable(schema, name string, cascade bool) error

+ func (d *Database) DropTableContext(ctx context.Context, schema, name string, cascade bool) error

+ func (d *Database) DropUser(name string) error

+ func (d *Database) DropUserContext(ctx context.Context, name string) error

+ func (d *Database) ExtendedProperties(level ExtendedPropertyLevel) ([]*ExtendedProperty, error)

+ func (d *Database) FileGroups() ([]*FileGroup, error)

+ func (d *Database) FileGroupsContext(ctx context.Context) ([]*FileGroup, error)

+ func (d *Database) ID() int

+ func (d *Database) IsReadOnly() bool

+ func (d *Database) Name() string

+ func (d *Database) PartitionFunctions() ([]*PartitionFunction, error)

+ func (d *Database) PartitionSchemes() ([]*PartitionScheme, error)

+ func (d *Database) RecoveryModel() RecoveryModel

+ func (d *Database) RemoveRoleMember(roleName, memberName string) error

+ func (d *Database) RemoveRoleMemberContext(ctx context.Context, roleName, memberName string) error

+ func (d *Database) RenameTable(schema, oldName, newName string) error

+ func (d *Database) RenameTableContext(ctx context.Context, schema, oldName, newName string) error

+ func (d *Database) SchemaSeq() iter.Seq2[*Schema, error]

+ func (d *Database) Schemas() ([]*Schema, error)

+ func (d *Database) SchemasContext(ctx context.Context) ([]*Schema, error)

+ func (d *Database) SecurityPolicies() ([]*SecurityPolicy, error)

+ func (d *Database) SequenceSeq() iter.Seq2[*Sequence, error]

+ func (d *Database) Sequences() ([]*Sequence, error)

+ func (d *Database) Server() *Server

+ func (d *Database) SetCompatibilityLevel(level CompatibilityLevel) error

+ func (d *Database) SetCompatibilityLevelContext(ctx context.Context, level CompatibilityLevel) error

+ func (d *Database) SetReadOnly(readOnly bool) error

+ func (d *Database) SetReadOnlyContext(ctx context.Context, readOnly bool) error

+ func (d *Database) SetRecoveryModel(model RecoveryModel) error

+ func (d *Database) SetRecoveryModelContext(ctx context.Context, model RecoveryModel) error

+ func (d *Database) SpaceUsed() (SpaceInfo, error)

+ func (d *Database) SpaceUsedContext(ctx context.Context) (SpaceInfo, error)

+ func (d *Database) State() string

+ func (d *Database) StoredProcedureSeq() iter.Seq2[*StoredProcedure, error]

+ func (d *Database) StoredProcedures() ([]*StoredProcedure, error)

+ func (d *Database) StoredProceduresContext(ctx context.Context) ([]*StoredProcedure, error)

+ func (d *Database) Synonyms() ([]*Synonym, error)

+ func (d *Database) TableByName(schema, name string) (*Table, error)

+ func (d *Database) TableByNameContext(ctx context.Context, schema, name string) (*Table, error)

+ func (d *Database) TableSeq() iter.Seq2[*Table, error]

+ func (d *Database) Tables() ([]*Table, error)

+ func (d *Database) TablesBySchema(schema string) ([]*Table, error)

+ func (d *Database) TablesBySchemaContext(ctx context.Context, schema string) ([]*Table, error)

+ func (d *Database) TablesContext(ctx context.Context) ([]*Table, error)

+ func (d *Database) Triggers() ([]*Trigger, error)

+ func (d *Database) TriggersContext(ctx context.Context) ([]*Trigger, error)

+ func (d *Database) UserDefinedFunctions() ([]*UserDefinedFunction, error)

+ func (d *Database) UserDefinedFunctionsContext(ctx context.Context) ([]*UserDefinedFunction, error)

+ func (d *Database) UserSeq() iter.Seq2[*User, error]

+ func (d *Database) Users() ([]*User, error)

+ func (d *Database) UsersContext(ctx context.Context) ([]*User, error)

+ func (d *Database) ViewSeq() iter.Seq2[*View, error]

+ func (d *Database) Views() ([]*View, error)

+ func (d *Database) ViewsContext(ctx context.Context) ([]*View, error)

+ type DatabaseFile struct

+ FileGroupName string

+ Growth int64

+ GrowthType string

+ IsPrimaryFile bool

+ MaxSize int64

+ Name string

+ PhysicalName string

+ Size int64

+ type DatabaseRole struct

+ ID int

+ IsFixedRole bool

+ Members []string

+ Name string

+ Owner string

+ type ErrorLogEntry struct

+ LogDate string

+ Process string

+ Text string

+ type ExtendedProperty struct

+ Name string

+ Value string

+ type ExtendedPropertyLevel struct

+ Level0Name string

+ Level0Type string

+ Level1Name string

+ Level1Type string

+ Level2Name string

+ Level2Type string

+ type FileGroup struct

+ Files []DatabaseFile

+ IsDefault bool

+ Name string

+ type ForeignKey struct

+ Columns []string

+ DeleteAction string

+ IsDisabled bool

+ IsNotForReplication bool

+ Name string

+ ReferencedColumns []string

+ ReferencedSchema string

+ ReferencedTable string

+ UpdateAction string

+ type Index struct

+ FillFactor int

+ FilterDefinition string

+ IncludedColumns []IndexColumn

+ IndexID int

+ IsClustered bool

+ IsDisabled bool

+ IsPrimaryKey bool

+ IsUnique bool

+ IsUniqueConstraint bool

+ KeyColumns []IndexColumn

+ Name string

+ Type IndexType

+ func (idx *Index) Disable(t *Table) error

+ func (idx *Index) DisableContext(ctx context.Context, t *Table) error

+ func (idx *Index) Drop(t *Table) error

+ func (idx *Index) DropContext(ctx context.Context, t *Table) error

+ func (idx *Index) Enable(t *Table) error

+ func (idx *Index) Rebuild(t *Table, fillFactor int) error

+ func (idx *Index) RebuildContext(ctx context.Context, t *Table, fillFactor int) error

+ func (idx *Index) Reorganize(t *Table) error

+ func (idx *Index) ReorganizeContext(ctx context.Context, t *Table) error

+ type IndexColumn struct

+ Descending bool

+ IsIncluded bool

+ Name string

+ type IndexColumnDef struct

+ Descending bool

+ Name string

+ type IndexFragmentation struct

+ AvgFragmentationPct float64

+ FragmentCount int64

+ IndexID int

+ IndexName string

+ PageCount int64

+ type IndexType string

+ const IndexTypeClustered

+ const IndexTypeColumnStore

+ const IndexTypeNonClustered

+ const IndexTypeSpatial

+ const IndexTypeXML

+ type Job struct

+ Category string

+ CurrentState JobState

+ DateCreated time.Time

+ DateModified time.Time

+ Description string

+ IsEnabled bool

+ JobID string

+ LastRunDate time.Time

+ LastRunDuration time.Duration

+ LastRunOutcome JobOutcome

+ Name string

+ NextRunDate time.Time

+ OwnerLoginName string

+ StartStepID int

+ func (j *Job) AddSchedule(req JobScheduleRequest) error

+ func (j *Job) AddScheduleContext(ctx context.Context, req JobScheduleRequest) error

+ func (j *Job) AddStep(req JobStepRequest) error

+ func (j *Job) AddStepContext(ctx context.Context, req JobStepRequest) error

+ func (j *Job) Disable() error

+ func (j *Job) Drop() error

+ func (j *Job) DropContext(ctx context.Context) error

+ func (j *Job) Enable() error

+ func (j *Job) History(limit int) ([]*JobHistoryEntry, error)

+ func (j *Job) HistoryContext(ctx context.Context, limit int) ([]*JobHistoryEntry, error)

+ func (j *Job) Start(stepName string) error

+ func (j *Job) StartContext(ctx context.Context, stepName string) error

+ func (j *Job) Steps() ([]*JobStep, error)

+ func (j *Job) StepsContext(ctx context.Context) ([]*JobStep, error)

+ func (j *Job) Stop() error

+ func (j *Job) StopContext(ctx context.Context) error

+ type JobHistoryEntry struct

+ Duration time.Duration

+ Message string

+ Outcome JobOutcome

+ RunDate time.Time

+ StepID int

+ StepName string

+ type JobOutcome int

+ const JobOutcomeCancelled

+ const JobOutcomeFailed

+ const JobOutcomeRetried

+ const JobOutcomeSucceeded

+ const JobOutcomeUnknown

+ type JobScheduleRequest struct

+ ActiveEndTime int

+ ActiveStartTime int

+ Enabled bool

+ FreqInterval int

+ FreqSubdayInterval int

+ FreqSubdayType int

+ FreqType int

+ Name string

+ type JobState int

+ const JobStateBetweenRetries

+ const JobStateCancelling

+ const JobStateExecuting

+ const JobStateIdle

+ const JobStatePerformingCompletionActions

+ const JobStateRunning

+ const JobStateSuspended

+ const JobStateWaitingForWorker

+ type JobStep struct

+ Command string

+ LastRunDuration int

+ LastRunOutcome JobOutcome

+ Name string

+ OnFailAction int

+ OnSuccessAction int

+ RetryAttempts int

+ RetryInterval int

+ StepID int

+ Subsystem string

+ type JobStepRequest struct

+ Command string

+ Database string

+ Name string

+ OnFailAction int

+ OnSuccessAction int

+ RetryAttempts int

+ RetryInterval int

+ Subsystem string

+ type LinkedServer struct

+ DataSource string

+ IsRemote bool

+ Name string

+ Product string

+ Provider string

+ type Login struct

+ CreateDate time.Time

+ DefaultDatabase string

+ IsDisabled bool

+ LoginType string

+ ModifyDate time.Time

+ Name string

+ SID []byte

+ func (l *Login) AddServerRoleMember(roleName string) error

+ func (l *Login) AddServerRoleMemberContext(ctx context.Context, roleName string) error

+ func (l *Login) ChangePassword(newPassword string) error

+ func (l *Login) ChangePasswordContext(ctx context.Context, newPassword string) error

+ func (l *Login) Disable() error

+ func (l *Login) DisableContext(ctx context.Context) error

+ func (l *Login) Drop() error

+ func (l *Login) Enable() error

+ func (l *Login) EnableContext(ctx context.Context) error

+ func (l *Login) RemoveServerRoleMember(roleName string) error

+ func (l *Login) RemoveServerRoleMemberContext(ctx context.Context, roleName string) error

+ type MailProfile struct

+ Description string

+ IsDefault bool

+ Name string

+ ProfileID int

+ type ObjectPermission string

+ const PermControl

+ const PermDelete

+ const PermExecute

+ const PermInsert

+ const PermSelect

+ const PermUpdate

+ const PermView

+ type PartitionFunction struct

+ Boundaries []string

+ BoundaryCount int

+ FunctionID int

+ InputType DataType

+ IsRight bool

+ Name string

+ func (pf *PartitionFunction) Drop() error

+ func (pf *PartitionFunction) MergeRange(value string) error

+ func (pf *PartitionFunction) SplitRange(value string) error

+ type PartitionInfo struct

+ DataCompression string

+ PartitionNumber int

+ Rows int64

+ type PartitionScheme struct

+ FileGroups []string

+ FunctionName string

+ Name string

+ SchemeID int

+ func (ps *PartitionScheme) Drop() error

+ type PermissionState string

+ const PermissionDeny

+ const PermissionGrant

+ const PermissionRevoke

+ type RecoveryModel string

+ const RecoveryModelBulkLogged

+ const RecoveryModelFull

+ const RecoveryModelSimple

+ type RelocateFile struct

+ LogicalName string

+ PhysicalName string

+ type RestoreOptions struct

+ Action BackupAction

+ Checksum bool

+ Database string

+ Devices []string

+ NoRecovery bool

+ Recovery bool

+ RelocateFiles []RelocateFile

+ Replace bool

+ StandBy string

+ Stats int

+ StopAt *time.Time

+ type Schema struct

+ ID int

+ Name string

+ Owner string

+ func (s *Schema) ChangeOwner(newOwner string) error

+ func (s *Schema) ChangeOwnerContext(ctx context.Context, newOwner string) error

+ func (s *Schema) Drop() error

+ type ScriptOptions struct

+ AnsiPadding bool

+ IncludeHeaders bool

+ IncludeIfNotExists bool

+ SchemaQualify bool

+ ScriptDrops bool

+ func DefaultScriptOptions() ScriptOptions

+ type Scripter struct

+ func NewScripter(db *Database, opts ScriptOptions) *Scripter

+ func (sc *Scripter) ScriptDatabase() (string, error)

+ func (sc *Scripter) ScriptFunction(schema, name string) (string, error)

+ func (sc *Scripter) ScriptFunctionContext(ctx context.Context, schema, name string) (string, error)

+ func (sc *Scripter) ScriptStoredProcedure(schema, name string) (string, error)

+ func (sc *Scripter) ScriptStoredProcedureContext(ctx context.Context, schema, name string) (string, error)

+ func (sc *Scripter) ScriptTable(schema, name string) (string, error)

+ func (sc *Scripter) ScriptTableContext(ctx context.Context, schema, name string) (string, error)

+ func (sc *Scripter) ScriptView(schema, name string) (string, error)

+ func (sc *Scripter) ScriptViewContext(ctx context.Context, schema, name string) (string, error)

+ type SecurityPolicy struct

+ IsEnabled bool

+ IsNotForReplication bool

+ Name string

+ ObjectID int

+ Predicates []*SecurityPredicate

+ Schema string

+ func (p *SecurityPolicy) Disable() error

+ func (p *SecurityPolicy) Drop() error

+ func (p *SecurityPolicy) Enable() error

+ type SecurityPredicate struct

+ Operation string

+ PredicateDefinition string

+ PredicateType string

+ TargetSchema string

+ TargetTable string

+ type Sequence struct

+ CacheSize int

+ CurrentValue int64

+ DataType DataType

+ Increment int64

+ IsCached bool

+ IsCycling bool

+ MaxValue int64

+ MinValue int64

+ Name string

+ ObjectID int

+ Schema string

+ StartValue int64

+ func (seq *Sequence) Drop() error

+ func (seq *Sequence) NextValue() (int64, error)

+ func (seq *Sequence) Restart(value int64) error

+ type Server struct

+ func Connect(opts ConnectionOptions) (*Server, error)

+ func ConnectContext(ctx context.Context, opts ConnectionOptions) (*Server, error)

+ func (s *Server) ActiveSessions(includeSystem bool) ([]*ActiveSession, error)

+ func (s *Server) ActiveSessionsContext(ctx context.Context, includeSystem bool) ([]*ActiveSession, error)

+ func (s *Server) Backup(opts BackupOptions) error

+ func (s *Server) BackupContext(ctx context.Context, opts BackupOptions) error

+ func (s *Server) BackupHistory(databaseName string) ([]*BackupInfo, error)

+ func (s *Server) BackupHistoryContext(ctx context.Context, databaseName string) ([]*BackupInfo, error)

+ func (s *Server) Close() error

+ func (s *Server) ConfigurationByName(name string) (*ConfigurationOption, error)

+ func (s *Server) ConfigurationByNameContext(ctx context.Context, name string) (*ConfigurationOption, error)

+ func (s *Server) Configurations() ([]*ConfigurationOption, error)

+ func (s *Server) ConfigurationsContext(ctx context.Context) ([]*ConfigurationOption, error)

+ func (s *Server) CreateDatabase(name string, opts *CreateDatabaseOptions) error

+ func (s *Server) CreateDatabaseContext(ctx context.Context, name string, opts *CreateDatabaseOptions) error

+ func (s *Server) CreateJob(req CreateJobRequest) (*Job, error)

+ func (s *Server) CreateJobContext(ctx context.Context, req CreateJobRequest) (*Job, error)

+ func (s *Server) CreateLogin(name, password string, opts *CreateLoginOptions) error

+ func (s *Server) CreateLoginContext(ctx context.Context, name, password string, opts *CreateLoginOptions) error

+ func (s *Server) CycleErrorLog() error

+ func (s *Server) CycleErrorLogContext(ctx context.Context) error

+ func (s *Server) DB() *sql.DB

+ func (s *Server) DatabaseByName(name string) (*Database, error)

+ func (s *Server) DatabaseByNameContext(ctx context.Context, name string) (*Database, error)

+ func (s *Server) DatabaseSeq() iter.Seq2[*Database, error]

+ func (s *Server) Databases() ([]*Database, error)

+ func (s *Server) DatabasesContext(ctx context.Context) ([]*Database, error)

+ func (s *Server) DropDatabase(name string, force bool) error

+ func (s *Server) DropDatabaseContext(ctx context.Context, name string, force bool) error

+ func (s *Server) DropLogin(name string) error

+ func (s *Server) DropLoginContext(ctx context.Context, name string) error

+ func (s *Server) Info() *ServerInfo

+ func (s *Server) JobByName(name string) (*Job, error)

+ func (s *Server) JobByNameContext(ctx context.Context, name string) (*Job, error)

+ func (s *Server) JobSeq() iter.Seq2[*Job, error]

+ func (s *Server) Jobs() ([]*Job, error)

+ func (s *Server) JobsContext(ctx context.Context) ([]*Job, error)

+ func (s *Server) KillSession(sessionID int) error

+ func (s *Server) KillSessionContext(ctx context.Context, sessionID int) error

+ func (s *Server) LinkedServers() ([]*LinkedServer, error)

+ func (s *Server) LinkedServersContext(ctx context.Context) ([]*LinkedServer, error)

+ func (s *Server) LoginSeq() iter.Seq2[*Login, error]

+ func (s *Server) Logins() ([]*Login, error)

+ func (s *Server) LoginsContext(ctx context.Context) ([]*Login, error)

+ func (s *Server) MailProfiles() ([]*MailProfile, error)

+ func (s *Server) MailProfilesContext(ctx context.Context) ([]*MailProfile, error)

+ func (s *Server) Name() string

+ func (s *Server) ReadErrorLog(logNumber int) ([]*ErrorLogEntry, error)

+ func (s *Server) ReadErrorLogContext(ctx context.Context, logNumber int) ([]*ErrorLogEntry, error)

+ func (s *Server) Reconfigure(override bool) error

+ func (s *Server) ReconfigureContext(ctx context.Context, override bool) error

+ func (s *Server) Restore(opts RestoreOptions) error

+ func (s *Server) RestoreContext(ctx context.Context, opts RestoreOptions) error

+ func (s *Server) SendMail(profile, recipients, subject, body string) error

+ func (s *Server) SendMailContext(ctx context.Context, profile, recipients, subject, body string) error

+ func (s *Server) ServerRoles() ([]*ServerRole, error)

+ func (s *Server) ServerRolesContext(ctx context.Context) ([]*ServerRole, error)

+ type ServerInfo struct

+ Collation string

+ DefaultBackupPath string

+ DefaultDataPath string

+ DefaultLogPath string

+ Edition string

+ IsClustered bool

+ IsHADREnabled bool

+ LogicalCPUCount int

+ MaxConnections int

+ Name string

+ OSVersion string

+ PhysicalMemoryMB int64

+ Platform string

+ ProductLevel string

+ ProductVersion string

+ VersionBuild int

+ VersionMajor int

+ VersionMinor int

+ type ServerRole struct

+ IsFixedRole bool

+ Members []string

+ Name string

+ type ServerVersion int

+ const SQLServer2012

+ const SQLServer2014

+ const SQLServer2016

+ const SQLServer2017

+ const SQLServer2019

+ const SQLServer2022

+ type SpaceInfo struct

+ DataMB float64

+ LogMB float64

+ TotalMB float64

+ type Statistic struct

+ FilterDef string

+ HasFilter bool

+ IsAutoCreated bool

+ IsUserCreated bool

+ LastUpdated time.Time

+ Name string

+ RowsSampled int64

+ StatID int

+ Steps int

+ TotalRows int64

+ UnfilteredRows int64

+ func (st *Statistic) Drop() error

+ func (st *Statistic) DropContext(ctx context.Context) error

+ func (st *Statistic) Update(samplePct int) error

+ func (st *Statistic) UpdateContext(ctx context.Context, samplePct int) error

+ type StoredProcedure struct

+ CreateDate time.Time

+ Definition string

+ ModifyDate time.Time

+ Name string

+ ObjectID int

+ Schema string

+ type Synonym struct

+ BaseObject string

+ Name string

+ ObjectID int

+ Schema string

+ func (syn *Synonym) Drop() error

+ type Table struct

+ CreateDate time.Time

+ HasReplicationFilter bool

+ IsMemoryOptimized bool

+ ModifyDate time.Time

+ Name string

+ ObjectID int

+ Schema string

+ func (t *Table) CheckConstraints() ([]*CheckConstraint, error)

+ func (t *Table) CheckConstraintsContext(ctx context.Context) ([]*CheckConstraint, error)

+ func (t *Table) ColumnSeq() iter.Seq2[*Column, error]

+ func (t *Table) Columns() ([]*Column, error)

+ func (t *Table) ColumnsContext(ctx context.Context) ([]*Column, error)

+ func (t *Table) CreateIndex(req CreateIndexRequest) error

+ func (t *Table) CreateIndexContext(ctx context.Context, req CreateIndexRequest) error

+ func (t *Table) CreateStatistic(name string, columns []string, samplePct int) error

+ func (t *Table) CreateStatisticContext(ctx context.Context, name string, columns []string, samplePct int) error

+ func (t *Table) DB() *Database

+ func (t *Table) ForeignKeySeq() iter.Seq2[*ForeignKey, error]

+ func (t *Table) ForeignKeys() ([]*ForeignKey, error)

+ func (t *Table) ForeignKeysContext(ctx context.Context) ([]*ForeignKey, error)

+ func (t *Table) FragmentationStats(mode string) ([]*IndexFragmentation, error)

+ func (t *Table) FragmentationStatsContext(ctx context.Context, mode string) ([]*IndexFragmentation, error)

+ func (t *Table) FullName() string

+ func (t *Table) IndexSeq() iter.Seq2[*Index, error]

+ func (t *Table) Indexes() ([]*Index, error)

+ func (t *Table) IndexesContext(ctx context.Context) ([]*Index, error)

+ func (t *Table) Partitions() ([]*PartitionInfo, error)

+ func (t *Table) RebuildAllIndexes(fillFactor int) error

+ func (t *Table) RebuildAllIndexesContext(ctx context.Context, fillFactor int) error

+ func (t *Table) RowCount() (int64, error)

+ func (t *Table) RowCountContext(ctx context.Context) (int64, error)

+ func (t *Table) StatisticSeq() iter.Seq2[*Statistic, error]

+ func (t *Table) Statistics() ([]*Statistic, error)

+ func (t *Table) StatisticsContext(ctx context.Context) ([]*Statistic, error)

+ func (t *Table) TruncateTable() error

+ func (t *Table) TruncateTableContext(ctx context.Context) error

+ func (t *Table) UpdateAllStatistics(samplePct int) error

+ func (t *Table) UpdateAllStatisticsContext(ctx context.Context, samplePct int) error

+ type Trigger struct

+ Definition string

+ Events []string

+ IsEnabled bool

+ Name string

+ Schema string

+ TableName string

+ type User struct

+ AuthType string

+ CreateDate time.Time

+ DefaultSchema string

+ ID int

+ ModifyDate time.Time

+ Name string

+ UserType string

+ func (u *User) AddToRole(roleName string) error

+ func (u *User) Deny(permission ObjectPermission, objectSchema, objectName string) error

+ func (u *User) DenyContext(ctx context.Context, permission ObjectPermission, ...) error

+ func (u *User) Drop() error

+ func (u *User) Grant(permission ObjectPermission, objectSchema, objectName string) error

+ func (u *User) GrantContext(ctx context.Context, permission ObjectPermission, ...) error

+ func (u *User) RemoveFromRole(roleName string) error

+ func (u *User) Revoke(permission ObjectPermission, objectSchema, objectName string) error

+ func (u *User) RevokeContext(ctx context.Context, permission ObjectPermission, ...) error

+ type UserDefinedFunction struct

+ CreateDate time.Time

+ Definition string

+ FuncType string

+ ModifyDate time.Time

+ Name string

+ ObjectID int

+ Schema string

+ type View struct

+ CreateDate time.Time

+ Definition string

+ ModifyDate time.Time

+ Name string

+ ObjectID int

+ Schema string

v0.0.0-alpha.0

Jun 23, 2026

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL