- 1

is there any different between delete table and delete from table?

12th Sep 2016, 3:20 PM
ali
ali - avatar
3 ответов
0
yes there is a different delete table means your deleting all the rows and columns in other delet frm table dat is Your deleting frm table either a row or column
12th Sep 2016, 3:45 PM
Esshan Sahukar
Esshan Sahukar - avatar
0
I think delete is not used....in the SQL.....for deleting any data from the database either from the row or the column you have to use....delete from....and as per the condition of deletion u can make it with where clause... And for deleting all the rows and columns u can use truncate....it function is to recreate the schema..and deleting all the data.. And for deleting schema, rows and columns use drop table SQL statements ....I hope u understood
12th Sep 2016, 5:37 PM
Nitesh Yadav
Nitesh Yadav - avatar
0
i try both of them with where clause in microsoft sql server 2008 and they have same result
13th Sep 2016, 3:29 AM
ali
ali - avatar