When viewing a table in the GUI tools table design window in SQL Server,the notation that should supply the values for a surrogate key is that the Identity property of that column is set to "Yes."

Question

Quizplus · Accepted Answer

Setting the Identity property to "Yes" means that SQL Server will automatically generate a unique value for that column when a new row is inserted into the table, which is commonly used for surrogate keys.

When Viewing a Table in the GUI Tools Table Design