Table creation: Difference between revisions
Content added Content deleted
(Making) |
No edit summary |
||
Line 105: | Line 105: | ||
"databases:1234/conn_test"], "Username" -> "test"] |
"databases:1234/conn_test"], "Username" -> "test"] |
||
SQLCreateTable[conn, SQLTable["TEST"],If[Length[#] == 0,SQLColumn[StringJoin[#,"COL"],"DataTypeName" -> #],SQLColumn[StringJoin[#[[1]], "COL"], "DataTypeName" -> #[[1]],"DataLength" -> #[[2]]]] & /@ {"TINYINT", "SMALLINT", "INTEGER","BIGINT", "NUMERIC", "DECIMAL", "FLOAT", "REAL", "DOUBLE", "BIT","LONGVARBINARY", "VARBINARY", "BINARY","LONGVARCHAR",{"VARCHAR", 5},{"CHAR", 3},"DATE","TIME","TIMESTAMP","OBJECT"}]</lang> |
SQLCreateTable[conn, SQLTable["TEST"],If[Length[#] == 0,SQLColumn[StringJoin[#,"COL"],"DataTypeName" -> #],SQLColumn[StringJoin[#[[1]], "COL"], "DataTypeName" -> #[[1]],"DataLength" -> #[[2]]]] & /@ {"TINYINT", "SMALLINT", "INTEGER","BIGINT", "NUMERIC", "DECIMAL", "FLOAT", "REAL", "DOUBLE", "BIT","LONGVARBINARY", "VARBINARY", "BINARY","LONGVARCHAR",{"VARCHAR", 5},{"CHAR", 3},"DATE","TIME","TIMESTAMP","OBJECT"}]</lang> |
||
=={{header|Oracle}}== |
|||
Great SCOTT! from utlsampl.sql |
|||
<lang sql> |
|||
CREATE TABLE EMP |
|||
(EMPNO NUMBER(4) CONSTRAINT PK_EMP PRIMARY KEY, |
|||
ENAME VARCHAR2(10), |
|||
JOB VARCHAR2(9), |
|||
MGR NUMBER(4), |
|||
HIREDATE DATE, |
|||
SAL NUMBER(7,2), |
|||
COMM NUMBER(7,2), |
|||
DEPTNO NUMBER(2) CONSTRAINT FK_DEPTNO REFERENCES DEPT); |
|||
</lang> |
|||
=={{header|Oz}}== |
=={{header|Oz}}== |