Function
Static Public Summary | ||
public |
describeTable(qi: QueryInterface, tableName: string, options: Object): Promise<Object> Describe a table structure |
Static Public
public describeTable(qi: QueryInterface, tableName: string, options: Object): Promise<Object> source
Describe a table structure
This method returns an array of hashes containing information about all attributes in the table.
{
name: {
type: 'VARCHAR(255)', // this will be 'CHARACTER VARYING' for pg!
allowNull: true,
defaultValue: null,
unique: true, // available for sqlite only
references: {}, // available for sqlite only
},
isBetaMember: {
type: 'TINYINT(1)', // this will be 'BOOLEAN' for pg!
allowNull: false,
defaultValue: false,
unique: false, // available for sqlite only
references: {}, // available for sqlite only
}
}
Params:
Name | Type | Attribute | Description |
qi | QueryInterface | ||
tableName | string | table name |
|
options | Object |
|
Query options |