Post reply

table

  • August 16, 2013 at 11:24 pm

    #281184

    truncate table

  • August 17, 2013 at 2:32 am

    #1642387

    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

  • August 18, 2013 at 9:34 am

    #1642498

    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 🙂

  • August 19, 2013 at 6:09 am

    #1642629

    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

  • August 19, 2013 at 12:14 pm

    #1642804

    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'

  • August 19, 2013 at 5:46 pm

    #1642914

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

  • August 20, 2013 at 5:48 am

    #1643018

    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