Data Type Names In Powershell - Identity Increment

• cajun_sql

  SSCommitted

  Points: 1868

  More actions

  April 10, 2025 at 8:57 pm

  #4577038

  I am working with a script to exclude certain data types, and I was wondering if there is a comprehensive listing of the system.<datatype> for each of the mssql data types?

  For example, my code includes data types to exclude.  Here, in part:

  Exclude-ColumnsByType -ExcludeType System.String, System.DateTime |
  

  In particular, how would I specify a data types Identity with Auto Increment?  (Identity Increment=1 and Identity Seed=1)

  When I include system.identity, I don't get the result desired.

  Thanks!

• Phil Parkin

  SSC Guru

  Points: 247158

  More actions

  April 11, 2025 at 8:22 am

  #4577266

  cajun_sql wrote:

  I am working with a script to exclude certain data types, and I was wondering if there is a comprehensive listing of the system.<datatype> for each of the mssql data types?

  For example, my code includes data types to exclude.  Here, in part:

  Exclude-ColumnsByType -ExcludeType System.String, System.DateTime |
  

  In particular, how would I specify a data types Identity with Auto Increment?  (Identity Increment=1 and Identity Seed=1)

  When I include system.identity, I don't get the result desired.

  Thanks!

  Identity is a property, not a datatype. The datatypes having the identity property are usually INT and BIGINT.

  ---

• cajun_sql

  SSCommitted

  Points: 1868

  More actions

  April 11, 2025 at 5:15 pm

  #4577547

  Phil Parkin wrote:

  cajun_sql wrote:

  I am working with a script to exclude certain data types, and I was wondering if there is a comprehensive listing of the system.<datatype> for each of the mssql data types?

  For example, my code includes data types to exclude.  Here, in part:

  Exclude-ColumnsByType -ExcludeType System.String, System.DateTime |
  

  In particular, how would I specify a data types Identity with Auto Increment?  (Identity Increment=1 and Identity Seed=1)

  When I include system.identity, I don't get the result desired.

  Thanks!

  Identity is a property, not a datatype. The datatypes having the identity property are usually INT and BIGINT.

  Thanks very much.

  Is there a way to specify the property, along with the datatype, in the powershell code?

   

  • This reply was modified 1 month, 3 weeks ago by cajun_sql. Reason: addition