Hi all.

How can i know if a column of a table is generated?

Thank you

Francisco


You need to read the TableColumns table in Information.

In EDBManager open the database you're interested in, open a new query and enter

SELECT * FROM Information.TableColumns
WHERE
Generated = TRUE
AND
TableName = 'tablewanted'
AND
Name = 'column wanted'

Inside an app you could use the same query in the edbdatabase's Execute method and test for it returning > 0

Roy Lambert [Team Elevate]

Roy.

Thank's and regards