Create Statement Vanilla

Database
Highlighted
Enthusiast

Create Statement Vanilla

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? 

1 REPLY 1
Ambassador

Re: Create Statement Vanilla

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;