Difference between TO and AS keywords in RENAME syntax

Database

Difference between TO and AS keywords in RENAME syntax

Hi,

I see that both the below statements execute fine.

RENAME TABLE "TestSchema"."Table1" TO "TestSchema"."Table1Ren"

RENAME TABLE "TestSchema"."Table1Ren" AS "TestSchema"."Table1";

Is there any difference between the "TO" and "AS" keywords?

Thanks,

Balaji

1 REPLY
Junior Contributor

Re: Difference between TO and AS keywords in RENAME syntax

Hi Balaji,

there's no difference, it's just a syntax variation.