United States (English) Sign in

Print This Topic Print Multiple Topics

Home 2012 2008 R2 2008 Previous Versions Library Forums

TechNet Library

SQL Server

SQL Server 2012

Product Documentation

Developer Reference for SQL Server 2012

Developer Reference

Developer's Guide (Database Engine)

SQL Server Management Objects

SQL Server Management Objects Reference

Microsoft.SqlServer.Management.Smo

Table Class

Table Methods

Alter Method

AlterWithNoCheck Method

ChangeSchema Method

CheckIdentityValue Method

CheckTable Method

CheckTableDataOnly Method

Create Method

Deny Method

DisableAllIndexes Method

Drop Method

EnableAllIndexes Method

EnumColumnPermissions Method

EnumForeignKeys Method

EnumFragmentation Method

EnumLastStatisticsUpdates Method

EnumObjectPermissions Method

EnumScript Method

Grant Method

Initialize Method

Rebuild Method

RebuildIndexes Method

RecalculateSpaceUsage Method

Rename Method

Revoke Method

Script Method

SwitchPartition Method

TruncateData Method

UpdateStatistics Method

This topic has not yet been rated - Rate this topic

Table.TruncateData Method

SQL Server 2012

Other Versions

Truncates the data in the table.

Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

public void TruncateData()

Examples

Creating, Altering, and Removing Tables

Reference

Table Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Tables

TRUNCATE TABLE (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD

Manage Your Profile

|

Site Feedback