# Name databases and SQL objects

Use Coordinator DB as the product name and choose application database names independently. A managed server database is created with `CREATE DATABASE`; creating it does not select it for the current connection.

```sql
CREATE DATABASE IF NOT EXISTS reporting;
USE reporting;
SELECT 1 AS connected FORMAT csv;
```

Managed database names ignore ASCII case. They begin with an ASCII letter or underscore, contain only ASCII letters, digits and underscores, and have at most 63 characters. `system` and `none` are reserved in any letter case.

For an HTTP query, select the database with the `database` URL parameter or put `USE` and its dependent statements in the same request. A later HTTP request has a separate session. An embedded connection instead opens a file or in-memory database and does not use these server commands.

Keep table and column names clear enough that predicates remain readable. When inspecting system metadata, include database and namespace information so identically named objects are not confused. Quote reserved identifiers in SQL rather than changing a metadata column's spelling.

See [`CREATE DATABASE`](https://coordinatordb.com/docs/reference/statements/create/database), [`USE`](https://coordinatordb.com/docs/reference/statements/use) and [qualified sources](https://coordinatordb.com/docs/reference/statements/select/from).