Results 1 to 3 of 3
  1. #1
    Join Date
    May 2003
    Posts
    8

    Unanswered: HOW to make a database blank through single command??

    Is there any way through which all the tables of database can be make blank through a single command.

    sumeet

  2. #2
    Join Date
    Jul 2003
    Posts
    55

    Re: HOW to make a database blank through single command??

    Originally posted by sumeet29
    Is there any way through which all the tables of database can be make blank through a single command.

    sumeet

    I think you should generate the SQL script for the tables, make sure to check the DROP, and CREATE options, besides you should check the Script Indexes, Script triggers, Script PRIMARY keys, and Script FOREIGN keys options.
    After running this script all tables will be dropped and created again, so should be blank.
    Hope this will help.

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    True, thats only the way even I know.

    BTW, why do you want to do so?
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •