Dotnetbites


CREATE TABLE Failed 3737: Name requires more than 30 bytes in LATIN internal form


Error :


Solution for the Error: CREATE TABLE Failed 3737: Name requires more than 30 bytes in LATIN internal form


Solution :


Teradata has some limitations in table and Column namings. While creating a Table in Teradata, The Name of the Table should not exceed 30 characters, If it has more than 30 characters, then this error would probably appear. This will apply to the column names as well




Statement - That causes Error





CREATE TABLE NothSideSalesAverageDetailsForSRSELF
(
SALE_Amount DECIMAL(12, 2) NOT NULL,
SALE_Average DECIMAL(12, 2) NOT NULL
)



If the above statement is getting executed, it would result in the 3707 Error. The TableName has more than 30 characters, It needs to be changed to the name that is less than the size 30




Corrected One





CREATE TABLE NothSideSalesAvgDetail_SRSELF
(
SALE_Amount DECIMAL(12, 2) NOT NULL,
SALE_Average DECIMAL(12, 2) NOT NULL
)



In the moment you change the table name to less than 31 characters, you will not get the error stating that Name requires more than 30 bytes in LATIN internal form.







Posted On : Monday, July 01, 2013