Table

Less than 1 minute

Methods

List all tables in the database.

public listTables(): void

Check if a table exists in the database.

public tableExists(string $tableName): bool

Parameter	Type	Description
`$tableName`	`string`

Create a new table in the database.

public createTable(string $tableName, mixed $columns): bool

Parameter	Type	Description
`$tableName`	`string`
`$columns`	`mixed`

Describe a table in the database.

public describeTable(string $tableName, ?string $sort, false $): void

Rename a table in the database.

public renameTable(string $fromName, string $toName): bool

Parameter	Type	Description
`$fromName`	`string`
`$toName`	`string`

Drop a table from the database.

public dropTable(string $name, bool $ifExists = false, bool $cascade = false): bool

Add a column to a table in the database.

public addColumn(string $tableName, mixed $columnSpec): bool

Parameter	Type	Description
`$tableName`	`string`
`$columnSpec`	`mixed`

Alter a column in a table in the database.

public alterColumn(string $tableName, string $column, mixed $columnSpec): bool

Drop a column from a table in the database.

public dropColumn(string $tableName, string $column, bool $ifExists = false): bool

Rename a column in a table in the database.

public truncate(string $tableName, bool $only = false, bool $restartIdentity = false, bool $cascade = false): bool