Cannot truncate table because it is being referenced by a FOREIGN KEY constraint?

by 
DELETE FROM TABLENAME
DBCC CHECKIDENT ('DATABASENAME.dbo.TABLENAME', RESEED, 0)

Note that this isn’t probably what you’d want if you have millions+ of records, as it’s very slow.

More Related Contents:

  1. T-SQL: Opposite to string concatenation – how to split string into multiple records [duplicate]
  2. How can foreign key constraints be temporarily disabled using T-SQL?
  3. Check if table exists in SQL Server
  4. Sql Server string to date conversion
  5. Insert multiple rows WITHOUT repeating the “INSERT INTO …” part of the statement?
  6. Does T-SQL have an aggregate function to concatenate strings? [duplicate]
  7. Parameter Sniffing (or Spoofing) in SQL Server
  8. How to get Time from DateTime format in SQL?
  9. SQL Server String or binary data would be truncated
  10. Datatype for storing ip address in SQL Server
  11. How to change identity column values programmatically?
  12. How much size “Null” value takes in SQL Server
  13. best way to convert and validate a date string
  14. SQL Server ORDER BY date and nulls last
  15. How to remove accents and all chars a..z in sql-server?
  16. Find non-ASCII characters in varchar columns using SQL Server
  17. WHERE clause on SQL Server “Text” data type
  18. SQL Server error on update command – “A severe error occurred on the current command”
  19. Aggregate bitwise-OR in a subquery
  20. SQL server schema and default schema
  21. Check if a string contains a substring in SQL Server 2005, using a stored procedure
  22. FOR XML PATH(”): Escaping “special” characters
  23. Cannot find either column “dbo” or the user-defined function or aggregate “dbo.Splitfn”, or the name is ambiguous
  24. Does query plan optimizer works well with joined/filtered table-valued functions?
  25. What are row, page and table locks? And when they are acquired?
  26. @@ERROR and/or TRY – CATCH
  27. How do I generate a random number for each row in a T-SQL select?
  28. Referring to a Column Alias in a WHERE Clause
  29. Combine multiple results in a subquery into a single comma-separated value
  30. Floor a date in SQL server

Leave a Comment