Which of the following will delete all the rows from the table T1
-
Delete * from table T1
-
Delete all from T1
-
Delete * from T1
-
Delete From T1
D
Correct answer
Explanation
To delete all rows from a table T1, use 'DELETE FROM T1'. Option A is incorrect because DELETE doesn't use '*'. Option B is incorrect because 'all' is not valid SQL syntax. Option C is incorrect for the same reason as A. The correct syntax is DELETE FROM table_name with no WHERE clause.