Teradata Studio products - choosing the right client tool
Teradata provides three Eclipse-based client tools, Teradata Studio, Teradata Studio Express, and Teradata Plug-in for Eclipse. All three products are built from the same code base and provide connectivity to your Teradata Database, but each has a different end user focus.
Teradata Studio Express is the base level product. It is an information discovery tool for retrieving and displaying data from your Teradata Database systems. Its main use is for running SQL statements, displaying result set data, and storing SQL execution history.