Forms Based Authentication: Deleting Users from Membership Tables

declare @numTablesDeletedFrom int

exec aspnet_Users_DeleteUser '/', 'username', 15, @numTablesDeletedFrom OUTPUT

select @numTablesDeletedFrom

note: 

1:         removes the user only from aspnet_membership 

15:       removes the user from all user tables 

More detail