Clean Database

**Pauliinho** · 16-02-10

how do i clean my database, removing all characters and accounts?

**MentaL**

**Linear88** · 16-02-10

Code:

DElETE * FROM table_name

Make sure that you delete data from tables with key constraints.

**Pauliinho** · 16-02-10

Code:

Msg 102, Level 15, State 1, Line 1
Sintaxe incorreta próxima a '*'.

Translated:

Code:

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '*'.

**alfredao** · 16-02-10

Code:

DElETE FROM table_name

or

Code:

TRUNCATE TABLE table_name

**Pauliinho** · 16-02-10

Thanks alfredao, it worked.

Re: Clean Database