sys.sp_special_columns

Description

Returns the optimal set of columns that uniquely identify a row in the table. Also returns columns automatically updated when any value in the row is updated by a transaction.

Syntax

sp_special_columns
[ @table_name = ]
N
'table_name'
[ , [ @table_owner = ]
N
'table_owner'
]
[ , [ @table_qualifier = ]
N
'table_qualifier'
]
[ , [ @col_type = ]
'col_type'
]
[ , [ @scope = ]
'scope'
]
[ , [ @nullable = ]
'nullable'
]
[ , [ @
ODBCV er = ]
ODBCV er ]
[ ; ]

Examples

Example 1

sp_special_columns

Example 2

SQLSpecialColumns

Example 3

SCOPE

Example 4

SELECT

Example 5

HumanResources.Department

Example 6

USE
AdventureWorks2022;
GO
EXECUTE sp_special_columns
@table_name =
'Department'
,
@table_owner =
'HumanResources'
;