SP is first removed if it already exists. WHERE keyword is optional in supplied where clause. When where clause is empty, all rows are selected