1 echo create table t1
(f1 varchar
(10), f2 smallint
);
3 echo create table t2
(f1 varchar
(10), f2 smallint
);
5 echo create index idx1 on t1
(f1
) hash;
7 echo create index idx2 on t2
(f1
) hash unique
;
9 Statement Executed
: Rows Affected
= 1
10 echo insert into t2 values
('Lakshya1',20);
11 Statement execute failed with error
-21
12 echo select * from t1
;
13 ---------------------------------------------------------
15 ---------------------------------------------------------
17 echo select * from t2
;
18 ---------------------------------------------------------
20 ---------------------------------------------------------
23 <Table Information of all tables
>
25 <TableName
> t1
</TableName
>
27 <FieldName
> f1
</FieldName
>
30 <Primary
> 0 </Primary
>
32 <Default
> 0 </Default
>
33 <DefaultValue
> </DefaultValue
>
36 <FieldName
> f2
</FieldName
>
39 <Primary
> 0 </Primary
>
41 <Default
> 0 </Default
>
42 <DefaultValue
> </DefaultValue
>
46 <TableName
> t2
</TableName
>
48 <FieldName
> f1
</FieldName
>
51 <Primary
> 0 </Primary
>
53 <Default
> 0 </Default
>
54 <DefaultValue
> </DefaultValue
>
57 <FieldName
> f2
</FieldName
>
60 <Primary
> 0 </Primary
>
62 <Default
> 0 </Default
>
63 <DefaultValue
> </DefaultValue
>
66 </Table Information of all tables
>
67 <Index Information of all Indexs
>
68 <Index Name
> idx1
</Index Name
>
69 <Index Type
> Hash Index
</Index Type
>
70 <Table Name
> t1
</Table Name
>
71 <Field Name
> f1
</Field Name
>
72 <Index Name
> idx2
</Index Name
>
73 <Index Type
> Hash Index
</Index Type
>
74 <Table Name
> t2
</Table Name
>
75 <Field Name
> f1
</Field Name
>
76 </Index Information of all Indexs
>