dbo.QBM_FGITableCountAll
SQL_SCALAR_FUNCTION
Created 2025-06-27T17:57:01.560 · modified 2026-04-14T23:14:10.520 · source: live DB sys.objects/sys.sql_expression_dependencies.
Parameters
| Name | Type | Output |
|---|---|---|
| bigint | yes |
@TableName | nvarchar | no |
Referenced objects
| Schema | Object | Column/minor | Class |
|---|---|---|---|
| No SQL expression dependencies in snapshot. | |||
Source excerpt
First extracted SQL definition lines from the exported source. Use the full source page for complete context.
1 create function dbo.QBM_FGITableCountAll( @TableName nvarchar(32) ) returns bigint as begin declare @erg bigint = -1 select top 1 @erg = 2y.CountItems from ( select sum(x.rows) as CountItems , x.TableName from ( select t.name as TableName, avg(p.rows) as rows , p.partition_number from sys.tables 3 t with (readpast) join sys.partitions p with (readpast) on t.object_id = p.object_id where t.name = @TableName group by t.name, p.partition_number ) as 4 x group by x.TableName ) as y return(@erg) end 5
Module relation graph
Loading module relation graph…
Source-derived context
Generated from exported SQL module definitions plus read-only sandbox sys.objects/sys.parameters/sys.sql_expression_dependencies metadata. This is factual source evidence, not a semantic guess.
provenance: SQL definition export provenance: sandbox DB metadata modified: 2026-04-14T23:14:10.520
None extracted.
Summary: reads/joins sys
Declared parameters
| Parameter | Type | Direction |
|---|---|---|
| bigint | OUTPUT |
@TableName | nvarchar(32) | input |
DML targets
None extracted.Called routines
None extracted.
Read/join references
SQL dependency metadata
None extracted.
Config/session
Config: None extracted.
Session: None extracted.
DBQueue/tasks
None extracted.Temp tables / referenced variables
Temp: None extracted.
Variables: @TableName @erg
Referenced by / reverse dependencies
Generated from live DB metadata, FK rows, and exported SQL dependency/source extraction. This is factual linkage evidence, not inferred behavior.
| Referencing object | Relation | Evidence |
|---|---|---|
| dbo.QBM_FGIDBQueueDeflateUsefull | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.ATT_PAttestationCaseCreate | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_PColumnCustomRemove | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_PDBQCS_CurrentRestore | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_PDBQueueCompress | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_PDBQueuePondEnd | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_PDialogDBQueueDelete | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_PJobQueueDelete | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_PProcessGroupCreate | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_PQBMDBQueueCurrentDelete | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_PQBMDBQueuePondDelete | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_PTableStatistics | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_ZJobHistoryShrink | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_ZProcessShrink | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_ZProgressViewShrink | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_ZWatchShrink | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_ZDynGroupSinglePerson | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.RMS_ZOrgHasESet | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.RMS_ZPersonHasESet | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_FTDBQCSOverviewLoad | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_TDBaseTreeHasObject | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_TDPersonHasObject | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_TIBaseTreeHasObject | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QER_TIPersonHasObject | SQL expression dependency | dbo · OBJECT_OR_COLUMN |
| dbo.QBM_VDBQueueContent | SQL expression dependency | dbo · OBJECT_OR_COLUMN |