On MSSQL, you can run a query by creating a database or a table without defining any column name, type etc ("create database test")
This doesn't seem like in Teradata?
You can't create a table without column in MS SQL Server (and probably all other DBMSes).
And to create a user you need to define at least the Perm Space, e.g. for a 1GB database:
create database test as perm = 1e+09;