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.
Latihan ini adalah bagian dari kursus
Creating PostgreSQL Databases
Latihan interaktif praktis
Cobalah latihan ini dengan menyelesaikan kode contoh berikut.
-- Create a table named 'bank' in the 'loan_504' schema
CREATE TABLE ___.bank (
id serial PRIMARY KEY,
___ VARCHAR (___) NOT NULL
);