V_QUERY_TABLESTATISTICS
Used to query table statistics for the system.
Fields
| Field | Field Type | Null | Description |
|---|---|---|---|
| SCHEMANAME | nvarchar(128) | yes | Schema name |
| TABLENAME | nvarchar(128) | yes | Table name |
| CATALOGID | uniqueidentifier | yes | System record ID |
| ROWCOUNT | int | yes | Row count |
| RESERVEDSPACEMB | int | yes | Reserved space (MB) |
| DATASIZEMB | int | yes | Data size (MB) |
| INDEXSIZEMB | int | yes | Index size (MB) |
| UNUSEDSPACEMB | int | yes | Unused space (MB) |
| ISAUDITTABLE | bit | yes | Is audit table |
| ISCUSTOMTABLE | bit | yes | Is custom table |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 8/17/2011 2:20:41 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.91.1535.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE VIEW dbo.V_QUERY_TABLESTATISTICS AS
select TS.SCHEMANAME,
TS.TABLENAME,
TS.CATALOGID,
TS.[ROWCOUNT],
--TS.RESERVEDSPACE,
(TS.RESERVEDSPACE / 1024) RESERVEDSPACEMB,
--TS.DATASIZE,
(TS.DATASIZE / 1024) DATASIZEMB,
--TS.INDEXSIZE,
(TS.INDEXSIZE / 1024) INDEXSIZEMB,
--TS.UNUSEDSPACE,
(TS.UNUSEDSPACE / 1024) UNUSEDSPACEMB,
TS.ISAUDITTABLE,
TS.ISCUSTOMTABLE
from dbo.UFN_TABLE_STATISTICS() TS