how to Rename a column in Synpase table which has periods ??

Question

how to Rename a column in Synpase table which has periods ??

Kulasekar Paranthaman 1

for example I have a table raw.SAM and it contains two columns SAM.ID,SAM.Name . now I want to rename the column to ID and Name , SP rename is not working

Vinodh247 34,566 Reputation points MVP Volunteer Moderator

2022-11-26T14:01:52.387+00:00

use proper quotes and brackets in the names you provide
PRADEEPCHEEKATLA 90,626 Reputation points Moderator

2022-11-30T06:42:10.257+00:00

Hello @Kulasekar Paranthaman ,

Just checking in to see if the below answer provided by @Evgeny Grishchenko & @Vinodh247 helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

1 answer

Your answer

Vinodh247 34,566 Reputation points MVP Volunteer Moderator

2022-11-26T14:01:52.387+00:00

use proper quotes and brackets in the names you provide
PRADEEPCHEEKATLA 90,626 Reputation points Moderator

2022-11-30T06:42:10.257+00:00

Hello @Kulasekar Paranthaman ,

Just checking in to see if the below answer provided by @Evgeny Grishchenko & @Vinodh247 helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

Answer 1

Evgeny Grishchenko 486

"If column names contain any characters except letters, numbers, and underscores, the name must be delimited by enclosing it in back quotes (`)."

Could you try?

Share via

how to Rename a column in Synpase table which has periods ??

1 answer

Your answer