Difference between revisions of "TABLEINFO()"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) (→See Also) |
||
Line 6: | Line 6: | ||
==See Also== | ==See Also== | ||
− | [[ALTER TABLE]], [[ALTER VIRTUALTABLE]], [[CREATE TABLE]], [[CREATE VIEW]], [[CREATE VIRTUALTABLE]], [[DBF()]], [[FILEINFO()]], [[SQL SELECT|SELECT]] | + | [[ALTER TABLE]], [[ALTER VIRTUALTABLE]], [[ATAGINFO()]], [[CREATE TABLE]], [[CREATE VIEW]], [[CREATE VIRTUALTABLE]], [[DBF()]], [[FILEINFO()]], [[SQL SELECT|SELECT]] |
==Description== | ==Description== |
Latest revision as of 11:43, 23 November 2021
Contents
Purpose
Function to return information about a table, virtual table or view
Syntax
TABLEINFO(<expC>)
See Also
ALTER TABLE, ALTER VIRTUALTABLE, ATAGINFO(), CREATE TABLE, CREATE VIEW, CREATE VIRTUALTABLE, DBF(), FILEINFO(), SELECT
Description
The TABLEINFO() function returns a pipe-separated string containing information about the table, virtual table or view specified in <expC>.
The following information is returned:
Table:
- Type - 'Table'
View:
- Type - 'View'
- Select statement
Virtual Table:
- Type - 'VirtualTable'
- Alias name
- Connection string
- Keyfieldlist column list
- Properties string
- Select statement
Example
open database mytables // Standard Lianja table ? tableinfo("ltable") Table // View ? tableinfo("lview") View|select * from customers // Virtual Table ? tableinfo("lvirtual") VirtualTable|lvirtual|awhr|currencycode||select * from sales.currency