SQL Table column names come different sometimes

Help Studio
, ,
1

Hello everyone,
I have a job that runs this query frequently <Select * from [TableName]>
Sometimes, some column name comes like PD but the original column name is PROCESS_ID. I don’t do anything to fix it because It turns to normal itself and It takes max 10 seconds. How is that possible?

2

@morkoccanbaran

The column names connot change like that unless the table is being recreated always

Cheers

3

That’s quite unusual. My suggestion would be to use column index instead of using column names