When reviewing a table in the SQL Server GUI tools,which property should be set to "Yes" to indicate that the column is a surrogate key for which SQL Server should automatically supply values?
A)Identity
B)Surrogate
C)AutoIncrement
D)AutoNumber

Question

Quizplus · Accepted Answer

The "Identity" property should be set to "Yes" to indicate that the column is a surrogate key, and SQL Server should automatically generate unique values for it. "Surrogate" is not a recognized property in SQL Server, while "AutoIncrement" and "AutoNumber" are properties used in other database systems.

When Reviewing a Table in the SQL Server GUI Tools,which