Client Login Area
Main Menu
Results 1 to 2 of 2

Thread: How to Check if a Column is Identity - MS SQL

  1. #1
    Verified Community Member seofast's Avatar
    Join Date
    July 2, 2010
    Posts
    22

    Default How to Check if a Column is Identity - MS SQL

    SELECT name, is_identity
    FROM sys.columns
    WHERE [object_id] = object_id('MyTable')

    This will list all the table column names with is_identity column value set to 1 if the column is identity.

  2. #2
    Verified Community Member Shani's Avatar
    Join Date
    April 24, 2010
    Posts
    97

    Default

    Thanks for sharing.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •