SQLTeam.com | Weblogs | Forums

Delete a SQL table from a DOS command


#1

My problem

I have a BCP command, which allows me to export a table to a .TXT file, I need to clear the table just after export

can I delete a SQL table from a DOS command

thanks


#2

You can use SQLCMD. There are some examples here.


#3

Thank you JamesK

I can not, can you help me:
1 / connect to the server (instance)
2 / use my database
3 / execute my query or my procedure

thank you


#4

Since I don't know the details of your database server, whatever I say is not going to be any better than what they have shown in that example. Were you able to open the link and looka t the example?

Assuming you are using integrated security, and that your servername is MyServer and that it is the default instance and that your database name is MyDatabase, and that your stored procedure name is MyStoredProc, what you would do is to run a command such as this from your command window

sqlcmd -S MyServer -d MyDatabase -Q "EXEC dbo.MyStoredProc"


#5

thanks it is ok


#6

If the table doesn't have Foreign Key constraints etc. then you could use

TRUNCATE TABLE MyTable

otherwise you will have to use

DELETE MyTable

The TRUNCATE TABLE is much more efficient, and uses very little log file space (whereas DELETE will log every row deleted)

Take a backup first!!