How to define varchar2

Question

I need to add a column with varchar2 data type in teradata sql ,

for example

ALTER TABLE table_name ADD column_name varchar2 (20);

But in teradata its not taking varchar2 as a defined type name.

You have tagged sql server, but the question says teradata. Which one are you working with? — James Z, Jan 23 '16 at 19:25

score 5 · Answer 1 · answered Jan 23 '16 at 19:17

5

varchar2 is an Oracle-specific datatype, not defined in the ANSI SQL standard. You should use the standard varchar type instead:

ALTER TABLE table_name ADD column_name VARCHAR(20);

answered Jan 23 '16 at 19:17

Mureinik

Here's a link to a list of Oracle to Teradata translation rules. https://teradataworld.wordpress.com/2013/10/27/oracle-to-teradata-migration-guidelines/ – Ben Jan 23 '16 at 19:25

score 1 · Answer 2 · edited May 23 '17 at 11:45

1

I think you should use NVARCHAR(20) - pay attention to that extra N in the type name, as it allows you to store Unicode strings.

edited May 23 '17 at 11:45

Community

answered Jan 23 '16 at 19:22

2 Answers2