Teradata Table Naming

Database
Enthusiast

Re: Teradata Table Naming

Thanks Tom. I also just found the "length" function usefull about doing a bit of googling.

sel * from dbc.tablesv where length(tablename) > 30

Re: Teradata Table Naming

What happens if I have some tables in the database which have names more than, lets say 30 chars long, and NameValidationRule now is set to 1? Do I have to first rename those tables?

Teradata Employee

Re: Teradata Table Naming

No, existing objects are not affected. The new Name Validation rule applies when you CREATE new objects (or for the new name specified on a RENAME).

Highlighted
Enthusiast

Re: Teradata Table Naming

MultiLoad and FastLoad aren't exactly obsolete -- they are still present in recent releases of TTU -- but I agree that you should use TPT nowadays. The MultiLoad and FastLoad partitions within the database are not obsolete, of course; they are used by TPT.