We can declare an
id_num so that
id_num will have an increment of unique numbers.
CREATE TABLE new_employees ( id_num int IDENTITY(1,1), fname varchar (20), minit char(1), lname varchar(30) )
Is it recommended to use
Identity as a alternative to
Primary key since
Identity provided a unique number for each row?