Name that table

Like all named objects in PostgreSQL, table names have certain restrictions as discussed in the previous lecture. To avoid issues when creating new tables, you should recognize which naming conventions are not allowed.

Deze oefening maakt deel uit van de cursus

Creating PostgreSQL Databases

Cursus bekijken

Oefeninstructies

Delete the CREATE TABLE commands below which contain invalid table names.

Praktische interactieve oefening

Probeer deze oefening eens door deze voorbeeldcode in te vullen.

-- Delete me and command below if this table name is invalid
CREATE TABLE 2for1 ();

-- Delete me and command below if this table name is invalid
CREATE TABLE customers ();

-- Delete me and command below if this table name is invalid
CREATE TABLE orders ();

-- Delete me and command below if this table name is invalid
CREATE TABLE service_rendered_by_other_provider ();

Code bewerken en uitvoeren