dbStorage: Storage Size

In MSSQL: Tools to Work with Microsoft SQL Server Databases via 'RODBC'

Storage Size

Description

Get storage size of tables in a database.

Usage

dbStorage(channel, total = TRUE, used = FALSE, unused = FALSE)

Arguments

channel	an RODBC connection.
total	whether to calculate total storage size.
used	whether to calculate used storage size.
unused	whether to calculate unused storage size.

Value

Data frame containing the following columns:

Name	name of table/view.
Schema	database schema.
Type	type of table/view.
Rows	number of rows.
Cols	number of columns.

In addition, any of the following columns, depending on which of total, used, and unused are TRUE:

TotalKB	total storage size.
UsedKB	used storage size.
UnusedKB	unused storage size.

Note

Based on https://stackoverflow.com/questions/7892334.

See Also

sqlQuery is the underlying function used to query ⁠sys.tables⁠, ⁠sys.indexes⁠, ⁠sys.partitions⁠, ⁠sys.allocation_units⁠, and ⁠sys.schemas⁠.

dbOverview shows the dimensions of tables/views and the first column names, and dbTime shows the time when tables/views were created and last modified.

object.size is the base function to return the storage size of objects inside the R workspace.

MSSQL-package gives an overview of the package.

Examples

## Not run: 
con <- odbcConnect("myDatabase")

dbOverview(con)

dbOverview(con, dim=FALSE, peek=FALSE)

## End(Not run)

MSSQL documentation built on Oct. 22, 2024, 9:06 a.m.