dbTime: Time Created and Modified

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

Time Created and Modified

Description

Get time information about tables and views: when they were created and when they were last modified.

Usage

dbTime(channel)

Arguments

channel

an RODBC connection.

Value

Data frame containing five columns:

Name	name of table/view.
Schema	database schema.
Type	type of table/view.
Created	time created.
Modified	time last modified.

See Also

sqlQuery is the underlying function used to query ⁠sys.tables⁠ and ⁠sys.views⁠.

dbOverview shows the dimensions of tables/views and the first column names, and dbStorage shows the storage size of tables.

Sys.time is the base function to show the current time.

MSSQL-package gives an overview of the package.

Examples

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

dbTime(con)

## End(Not run)

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