what is difference between teradata SQL and ANSI sql?

Database

what is difference between teradata SQL and ANSI sql?

Hi guys,
what is difference between teradata SQL and ANSI sql?

can any one explain me with a simple example ?

Regards,
bujji.
2 REPLIES

Re: what is difference between teradata SQL and ANSI sql?

i think there is no diffrenece. Td also accepts ANSI sql and but have some extra features like show,explain,help commands

Re: what is difference between teradata SQL and ANSI sql?

Hi,

TD is a default mode and ANSI is explicitly mode.
TD is Auto committed and in ANSI we need to write commit
TD is case sensitive and ANSI is not case sensitive
TD is default table is SET and ANSI default table is multiset

Regards,
Chakri