How to empty my database from SQL Server [closed]

Navigation
0

I would like to know how to empty my database, from SQL Server.

    
asked by Abraham Montes 29.05.2018 в 15:34
source

3 answers

3

You must truncate all your tables. 

TRUNCATE <<table>> ....

Help TRUNCATE command

    
answered by 29.05.2018 в 15:42
0

I recommend generating you table scripts, deleting the entire database
( drop database tubasededatos ) and launch the backup only of tables:

Original reply: StackOverflow

    
answered by 29.05.2018 в 15:52
0

Any of these should serve 

DROP DATABASE nombre; //es para eliminar una base de datos

DROP TABLE nombre; // es para eliminar una tabla

DELETE FROM nombre; //es para eliminar el contenido de una tabla

TRUNCATE TABLE nombre; //es para limpiar totalmente una tabla, el index vuelve a 0
    
answered by 29.05.2018 в 15:48
Can an Angular directive be added by Script? Error: Class '\ App \ User' not found in Laravel