|< < 6 > >|

Duplicates

Digression: Metadata of query results

Example 1


create table book(
    book_id int not null primary key,
    author_id int references author,
    title varchar not null,
    int year check(year > 0)    
);

What is the metadata for this table?

Table name: book
Column names: book_id, author_id, title, year
Column types: int, int, varchar, int
Column positions: 0, 1, 2, 3
Column constraints: year > 0
Primary key: book_id
Foreign key: author_id references author

|< < 6 > >|