Assume table name is EMPLOYEE and it has E_NAME Field
Delete All Rows In Tables
Delete All Rows In Tables
DELETE TABLE_NAME;Delete All Rows In Tables
DELETE EMPLOYEE;
DELETE FROM TABLE_NAME;Delete Selected Rows In Tables
DELETE FROM EMPLOYEE;
DELETE FROM TABLE_NAME WHERE CONDITION;Delete through Select Rows In Tables
DELETE FROM EMPLOYEE WHERE E_NAME = 'RAJU';
DELETE FROM (SELECT * FROM TABLE_NAME WHERE CONDITION);
DELETE FROM (SELECT * FROM EMPLOYEE WHERE E_NAME = 'RAJU');
No comments:
Post a Comment