- 1
is there any different between delete table and delete from table?
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
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
0
i try both of them with where clause in microsoft sql server 2008 and they have same result