1 Case
1: create two table t4
,t5
2 echo create table t4
(f1 int
,f2 int
,primary key
(f1
));
4 echo create table t5
(f1 int
,f2 int
,primary key
(f1
, f2
));
6 Case
2: With
-l option after
for primary flag checking
:
7 <Table Information of all tables
>
9 <TableName
> t4
</TableName
>
11 <FieldName
> f1
</FieldName
>
14 <Primary
> 1 </Primary
>
16 <Default
> 0 </Default
>
17 <DefaultValue
> </DefaultValue
>
20 <FieldName
> f2
</FieldName
>
23 <Primary
> 0 </Primary
>
25 <Default
> 0 </Default
>
26 <DefaultValue
> </DefaultValue
>
30 <TableName
> t5
</TableName
>
32 <FieldName
> f1
</FieldName
>
35 <Primary
> 1 </Primary
>
37 <Default
> 0 </Default
>
38 <DefaultValue
> </DefaultValue
>
41 <FieldName
> f2
</FieldName
>
44 <Primary
> 1 </Primary
>
46 <Default
> 0 </Default
>
47 <DefaultValue
> </DefaultValue
>
50 </Table Information of all tables
>
51 <Index Information of all Indexs
>
52 <Index Name
> t4_idx1_Primary
</Index Name
>
53 <Index Type
> Hash Index
</Index Type
>
54 <Table Name
> t4
</Table Name
>
55 <Field Name
> f1
</Field Name
>
56 <Index Name
> t5_idx1_Primary
</Index Name
>
57 <Index Type
> Hash Index
</Index Type
>
58 <Table Name
> t5
</Table Name
>
59 <Field Name
> f1
</Field Name
>
60 <Field Name
> f2
</Field Name
>
61 </Index Information of all Indexs
>
62 case 3 : drop two table