A table in SQL can have only one primary key. The primary key is used to uniquely identify each row in the table and ensure data integrity. It can consist of a single column or a combination of multiple columns, known as a composite key.