( ColumnType [(maximum_value)] | ENUM(value1, value2...) ) |
[ DEFAULT default value ] |
[ AUTO_INCREMENT ] |
[ PERMANENT ] |
[ PRIMARY KEY ]
In order to construct a CREATE TABLE query, this information will be useful. For more information on what possible ColumnTypes are available, see COLUMN TYPES. Also refer to column types for more details on the possible properties.
| Home Back Forward Refresh txtSQL Homepage |
|
txtSQL Documentation > SQL Syntax > Column Properties
|
Column Properties
|
txtSQL >= 3.0.0 Beta |
|
||
| No comments posted yet; |
| Last Page | Next Page |
'Language Reference'
User Functions
Database Functions
Data Manipulation Functions
Table Functions
Error Handling Functions
SQL Syntax
SELECT Syntax
INSERT Syntax
DELETE syntax
UPDATE Syntax
CREATE DATABASE Syntax
DROP DATABASE Syntax
SHOW DATABASES Syntax
USE Syntax
LOCK Syntax
UNLOCK Syntax
IS LOCKED Syntax
CREATE TABLE Syntax
DROP TABLE Syntax
SHOW TABLES Syntax
DESCRIBE Syntax
SHOW USERS Syntax
GRANT PERMISSIONS Syntax
Column Properties
Column Types
LIMIT Syntax
ORDERBY Syntax
WHERE Syntax