Example #1
0
        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();
        }
Example #2
0
 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 ");
     }
 }
Example #3
0
        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();
        }
Example #7
0
 protected override void BuildTruncateTable(SqlTruncateTableStatement truncateTable)
 {
     StringBuilder.Append("TRUNCATE TABLE ");
 }
Example #8
0
 protected override void BuildTruncateTable(SqlTruncateTableStatement truncateTable)
 {
     if (truncateTable.ResetIdentity || truncateTable.Table !.IdentityFields.Count == 0)
     {
         StringBuilder.Append("TRUNCATE TABLE ");
     }