protected override void BuildTruncateTableStatement(SqlTruncateTableStatement truncateTable) { var table = truncateTable.Table; base.AppendIndent(); base.StringBuilder.Append("TRUNCATE TABLE "); base.BuildPhysicalTable(table, null); base.StringBuilder.Append(" IMMEDIATE"); base.StringBuilder.AppendLine(); }
protected override void BuildTruncateTable(SqlTruncateTableStatement truncateTable) { if (truncateTable.ResetIdentity || truncateTable.Table.Fields.Values.All(f => !f.IsIdentity)) { StringBuilder.Append("TRUNCATE TABLE "); } else { StringBuilder.Append("DELETE FROM "); } }
protected override void BuildTruncateTableStatement(SqlTruncateTableStatement truncateTable) { var table = truncateTable.Table; AppendIndent(); StringBuilder.Append("TRUNCATE TABLE "); BuildPhysicalTable(table, null); if (truncateTable.ResetIdentity) { StringBuilder.Append(" RESTART IDENTITY"); } }
protected override void BuildTruncateTableStatement(SqlTruncateTableStatement truncateTable) { if (dataProvider.Options.IsVersion7_2orLater) { var table = truncateTable.Table; AppendIndent(); StringBuilder.Append("TRUNCATE TABLE "); BuildPhysicalTable(table, null); if (truncateTable.ResetIdentity) { StringBuilder.Append(" RESTART IDENTITY"); } } else { base.BuildTruncateTableStatement(truncateTable); } }
protected override void BuildTruncateTableStatement(SqlTruncateTableStatement truncateTable) { var table = truncateTable.Table; AppendIndent(); StringBuilder.Append("TRUNCATE TABLE "); BuildPhysicalTable(table, null); if (truncateTable.Table.Fields.Values.Any(f => f.IsIdentity)) { if (truncateTable.ResetIdentity) { StringBuilder.Append(" RESTART IDENTITY"); } else { StringBuilder.Append(" CONTINUE IDENTITY"); } } StringBuilder.AppendLine(); }
protected override void BuildTruncateTableStatement(SqlTruncateTableStatement truncateTable) { var table = truncateTable.Table; BuildTag(truncateTable); AppendIndent(); StringBuilder.Append("TRUNCATE TABLE "); BuildPhysicalTable(table !, null); if (truncateTable.Table !.IdentityFields.Count > 0) { if (truncateTable.ResetIdentity) { StringBuilder.Append(" RESTART IDENTITY"); } else { StringBuilder.Append(" CONTINUE IDENTITY"); } } StringBuilder.AppendLine(); }
protected override void BuildTruncateTable(SqlTruncateTableStatement truncateTable) { StringBuilder.Append("TRUNCATE TABLE "); }
protected override void BuildTruncateTable(SqlTruncateTableStatement truncateTable) { if (truncateTable.ResetIdentity || truncateTable.Table !.IdentityFields.Count == 0) { StringBuilder.Append("TRUNCATE TABLE "); }