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
E)Sequence

Question

Quizplus · Accepted Answer

The property that should be set to "Yes" to indicate that the column is a surrogate key for which SQL Server should automatically supply values is Identity. This property will automatically generate unique, sequential values for the column as new rows are inserted into the table. The other options listed (Surrogate, AutoIncrement, AutoNumber, and Sequence) either do not apply to SQL Server or are not the correct property to use for automatically generating surrogate key values.

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