Is there a character limit for the system prompt?

Yes, there is. Learn about the character size limit.

Can I delete prompts?

Currently, deleting a prompt isn’t supported, but stay tuned for changes in this area. As a workaround, prepend the prefix “DON’T USE - ,” “DEPRECATED - ” or something similar to the prompt name of any deprecated prompt.