At first glance SQL Assistant seems quite different from SQL Server Management Studio. However there are two options that go a long way in making SQL Assistant behave more like SSMS.
The first option to set will display all databases for which the user has access. This will make the database tree view in SQL Assistant a little more familiar for SSMS users.
Select Tools—>Options from within SQL Assistant.
Then click on DB Tree. Click on the 2nd radio button in the list. “Load the databases and users from a Table or View”.
The second option can be a lifesaver for a SQL Server DBA new to Teradata. By default SQL Assistant will run every script in the window regardless of what is highlighted. There is an option to change that.
On the Options window click on the Query tab and select – “Submit only the selected query text when highlighted”.
Hopefully these two options will ease the transition between SSMS and SQL Assistant.