hi
these r the basic questions in sql.
for removing the rows there r two options..
delete is a dml command u can rollback the values
truncat is dml command u cant rollback the values