SQL
Resolution of Type Names in the Schema
For [`CREATE TABLE` statements](#docs:sql:statements:create_table), DuckDB attempts to resolve type names in the schema where a table is created. For example:  
```sql
CREATE SCHEMA myschema;
CREATE TYPE myschema.mytype AS ENUM ('as', 'df');
CREATE TABLE myschema.mytable (v mytype);
```  
PostgreSQL returns an error on the last statement:  
```console
ERROR:  type "mytype" does not exist
LINE 1: CREATE TABLE myschema.mytable (v mytype);
^
```  
DuckDB runs the statement and creates the table successfully, confirmed by the following query:  
```sql
DESCRIBE myschema.mytable;
```  
```text
┌─────────────┬──────────────────┬─────────┬─────────┬─────────┬─────────┐
│ column_name │   column_type    │  null   │   key   │ default │  extra  │
│   varchar   │     varchar      │ varchar │ varchar │ varchar │ varchar │
├─────────────┼──────────────────┼─────────┼─────────┼─────────┼─────────┤
│ v           │ ENUM('as', 'df') │ YES     │ NULL    │ NULL    │ NULL    │
└─────────────┴──────────────────┴─────────┴─────────┴─────────┴─────────┘
```