Excellent. There is actually one more thing about
IDENTITY that you need to know. You can change its behavior! You do not need to start counting from 1, nor do you need to add 1 to every new value. Take a look:
CREATE TABLE movie (
After the keyword
IDENTITY, we put two values in the parentheses. The first one informs about the starting point value. In this case, the first row will obtain the number 3. The second value informs the database how it should calculate further values. In this case we're asking to add 5 each time. So, after 3, there come 8, 13, 18, ...