If you’re used to use auto_increment in MySQL. This is called Identity in MSSQL.
In the Designer you can find it in the rightpanel, when you’ve selected a table. You can select the field that needs to be autoincremented (most of the time that’s your key I guess.)