Data Type Names In Powershell - Identity Increment

Question

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!

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 247158 More actions · Answer 1

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 · Answer 2

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, 4 weeks ago by cajun_sql. Reason: addition