HomePage esProc Function Reference create() T.create () ＜Previous |

T.create ()

Read（832） Label: duplicate, new table sequence,

Description:

Create an empty table sequence by duplicating data structure of a specific table sequence.

Syntax:

T.create()

Note:

If table sequence T has a key, then duplicate the key at the same time.

Parameter:

T

A table sequence

Return value:

A new empty table sequence

Example:

Created from a normal table sequence :

 

A

 

1

=demo.query("select top 1 * from DEPARTMENT")

2

=A1.create()

 

Create an empty table of same structure as A1.

Copy the key

 

A

 

1

=demo.query("select * from DEPARTMENT ")

2

=A1.keys(DEPT)

 

3

=A1.create()

Create an empty table sequence that has not only the same data structure, but also the same key, as table sequence A1.