How to delete data from database

[sarang_k]

Hi all, Can any one tell me how to delete the data from the database. Thanks in advance.

[dan sh]

Whatever database you are using, it must be having a delete command. Use it.

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

[sarang_k]

i want to delete by using the query.

[dan sh]

Why can't you google or use the help provided with database? This is so very trivial. Anyways, here you go (assuming you are using MS SQL):

Delete from tableName where [whatever condition you want to use]

50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

[Ashfield]

If you don't even know how to use help, should you even consider doing a delete? Unless you know what you are doing you can lose more data than expected.

Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

[Niladri_Biswas]

I don't know your specific requirement, but I am giving certain situations. Let me know in case of any concern General syntax:

DELETE FROM
{table name | view name}
[WHERE search_conditions]

Note: Where clause is optional Case 1: Delete all rows from the table

Delete from tablename

Case 2: Delete based on a condition(Suppose I want to delete those employees from Employee table whose salaries are more than 50k)

Delete from Employees
where Salaries > 50000

Case 3: If you want to drop your table issue

DROP TABLE table_name

Case 4: Though you have not asked, but if incase you need to truncate your table issue :

Truncate Table table_name

Case 5: If you want to delete duplicate records like Input:

id name
1 name1
10 name1
2 name2
3 name3
11 name3
4 name4

Output:

id name
1 name1
2 name2
3 name3
4 name4

Query:

delete from tblname where id in
(
select id
from(select ROW_NUMBER() over(partition by name order by name) rn,
Id, name from tblname)X
where rn <> 1
)

But your question title is

sarang_k wrote:

delete the data from the database

Case 6: If that is suppose to be the case, the I presume you want to drop the database (:(don't know why?) However, the command is

Drop DataBase database_name

For more information please look into Deleting Data from an SQL Table Hope this helps :)

Niladri Biswas

[Mycroft Holmes]

I'm not sure that was a good idea, you just handed a complete novice, someone who cannot even find the simplest help topic, the code to drop and truncate tables. Talk about overkill, still he will learn something about data if he uses some of that. When he comes back with "I can't truncate the table", you can try explaining foreign keys :laugh: :laugh: :laugh: .

Never underestimate the power of human stupidity RAH

[Jorgen Andersson]

Mycroft Holmes wrote:

When he comes back with "I can't truncate the table", you can try explaining foreign keys

Or Cascade. ;P