Community

SQL SERVER – How to Find UNIQUE Key Columns? – sp_special_columns

(Pinal Dave) Unique key on a column is used to identify a particular row easily. It is created either by explicitly mentioning it either part of the definition or when defined as Primary key (By default it is unique and not null). Let us learn about special stored procedure sp_special_columns today.

Read More - Register for Free Membership