To help show the schema of your database, you can use the following procedures.
To help show the content of your database, what to do? Use simple SQL queries.
create table state_info (
rank
smallint,
abbrev
char(2),
description
char(255),
comments
char(255) default "None",
constraint infoconstr foreign key (rank,
abbrev) references states (rank, abbrev)
)
displays the constraint information for the states table. The state
table also has a foreign key to the state_info table. states and state_info
are defined as follows:
name | data |
states_popula_1088006907 | CHECK (population > 1000000) |
stateconstr | PRIMARY KEY INDEX (rank, abbrev): CLUSTERED, FOREIGN REFERENCE |
infoconstr | state_info FOREIGN KEY (rank, abbrev) REFERENCES states (rank, abbrev) |