Creating tables in existing schemas
The SBA provides twelve different funding opportunities. Two popular programs are the 7a and 504 programs. These loans have different purposes where 504 loans are typically used for real estate purchases and 7a loans are typically for general business needs. You have been tasked with the creation of tables which share a name but allow for different structures within their respective schemas. The schemas for these loans have already been created for you (named loan_7a
and loan_504
, respectively).
You will now put your knowledge to use to add new tables to these existing schemas.
This exercise is part of the course
Creating PostgreSQL Databases
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Create a table named 'bank' in the 'loan_504' schema
CREATE TABLE ___.bank (
id serial PRIMARY KEY,
___ VARCHAR (___) NOT NULL
);