Hi Team,
I have a table with considerable amount of data in Azure Synapse and i need to drop one column from this table. I am using the following query Alter table <TableName> Drop column <ColumnName> but am getting the following error:
Msg 5074, Level 16, State 1, Line 8
The statistics 'Stat_926ec45a53354b63b403c601944b7a38' is dependent on column 'Region'.
ALTER TABLE DROP COLUMN Region failed because one or more objects access this column.
The column Region which i am trying to drop is not used in any index.
I tried dropping the said statistics by using Drop Statistics TableName.Stat_926ec45a53354b63b403c601944b7a38
But its giving me error stating that this statistics doesn't exist.
How i can identify beforehand that which statistics needs to be deleted before deleting a column?
And how to delete this statistics?