SQL Server identity column

What a SQL Server identity column is and how it works: defining one in CREATE TABLE, uniqueness, finding them, adding,...