*TABLE_NAME

[Former Member]

WHAT DOES *TABLE NAME SPECIFIES?

[Former Member]

Hi,

This is used along with TABLES statement.

So if you want to create two strcutres of the same table using TABLES statement then use as follows.

TABLES: scarr, *scarr.

The avantage is

SELECT SINGLE *

FROM scarr

WHERE carrid = 'LH'.

SELECT SINGLE *

FROM *scarr

WHERE carrid = 'UA'.

*scarr behaves in a same way as scarr and even it works in SELECT statement and *scarr will be treated as scarr and data will be read from scarr. This usage is obsolete.

Regards,

Sesh

[Former Member]

Hi!

You can access this way a second header line of the table (it works like a work area, and it has the same sructure as the table).

It is a way obsolete.

Regards

Tamá

[seshatalpasai_madala]

Hi,

This is used along with TABLES statement.

So if you want to create two strcutres of the same table using TABLES statement then use as follows.

TABLES: scarr, *scarr.

The avantage is

SELECT SINGLE *

FROM scarr

WHERE carrid = 'LH'.

SELECT SINGLE *

FROM *scarr

WHERE carrid = 'UA'.

*scarr behaves in a same way as scarr and even it works in SELECT statement and *scarr will be treated as scarr and data will be read from scarr. This usage is obsolete.

Regards,

Sesh

[Former Member]

hi tushar,

*TABLE means the dummy table of original table TABLE

i will have the structure same as that of original table....but it wont be having any records..

hope this may help u...

please reward incase usefull...

regards,

prashant

[Former Member]

Hi

Check this linkl:-

http://dev.mysql.com/doc/maxdb/en/ef/3c89d8b11311d2a97100a0c9449261/content.htm

Thanks