Empty Table

[TamedTech]

Hello Guys,

I've recently migrated to MsSQL from MySQL, and in MySQL DBTools i used to be able to run a process called 'empty table' that would clear the entire content of a table.

Now, in MsSQL, during application development i've managed to accidentaly :-D fill a table with over a million results, and deleting is a bit of an issue.

What is the best way to clear all those records? Keep in mind i'm really new, so keep it simple :-D

Thanks,

Rob

 

[gmmastros]

In query analyzer....


Truncate Table [!]TableName[/!]



-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[TamedTech]

Thanks George, just what I wanted to hear.

I'll give it a go in the morning and let you know how i go.

Thanks,

Rob