minijebu
Valued Member
Points: 52
More actions
November 1, 2022 at 9:24 pm
#4107492
Hi,
I use SQL Server 2019.
Can I change the datatype of column in a partitioned table?
https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-table-transact-sql?view=sql-server-ver16
says:
The data type of a column of a partitioned table can't be changed.
But when I tried on my local instance , I was able to.
It did not throw any warnings or error.
How was that possible?
I am confused now.
Kind Regards
ratbak
Default port
Points: 1421
November 1, 2022 at 9:30 pm
#4107493
Based on other articles, it appears you can change the data type of a column not used in the partitioning function/primary key.
November 3, 2022 at 10:59 am
#4108142
Thanks ratbak.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply