Name

bif-show-table - display a table's SQL schema

Version

0.1.5_8 (yyyy-mm-dd)

Synopsis

bif show table NAME... [OPTIONS...]

Description

The bif-show-table command displays the SQL schema of a table in a repository.

bif show table projects
# CREATE TABLE nodes (
#     id INTEGER NOT NULL PRIMARY KEY,
#     uuid char(40) NOT NULL UNIQUE,
#     first_change_id INTEGER NOT NULL,
#     last_change_id INTEGER NOT NULL,
#     kind VARCHAR NOT NULL,
#     ctime INTEGER NOT NULL,
#     ctimetz INTEGER NOT NULL,
#     mtime INTEGER NOT NULL,
#     mtimetz INTEGER NOT NULL,
#     lang VARCHAR(8) NOT NULL DEFAULT 'en',
#     hash VARCHAR,
#     delta_id INTEGER NOT NULL DEFAULT (nextval('actions')),
#     num_changes INTEGER,
#     FOREIGN KEY(first_change_id) REFERENCES changes(id) ON DELETE CASCADE,
#     FOREIGN KEY(last_change_id) REFERENCES changes(id) ON DELETE NO ACTION
# )

Arguments & Options

NAME...
An SQL table name. Spaces or dashes are replaced with underscores to save typing.
--full, -f
Display indexes and triggers as well as the table definition.

See Also

bif(1)

Author

Mark Lawrence <nomad@null.net>

Copyright And License

Copyright 2014-2017 Mark Lawrence <nomad@null.net>

This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 3 of the License, or (at your option) any later version.