table

  • truncate table

  • What's the question here?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • I think "add poll" is the wrong command for you. It's for asking a question and let the people vote.

    Try to use "add topic" and ask your question again. The topic is for describing and discussing questions 🙂

  • WolfgangE (8/18/2013)


    I think "add poll" is the wrong command for you.

    Especially when there is only one answer to select from .. truncate table or ... nothing 🙂

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • There are plenty of scripts available to check for foreign key constraints and disable them, truncate then re-enable them. Also you should be aware of the difference between the truncate and delete commands.

    Do a google search like 'delete relation ships then truncate table'

  • I think he wants to just go for truncate table :-P. hence no other option

  • What are you expecting?:w00t:

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply