Getting a tables schema

[hog]

At present if I want to create an object that will give me the schema of the underlying tables I use a select statement that uses a bogus value which I know will return no records, but will give me the schema.

 

This is messy to say the least, so is there a more elegant/efficient method I can adopt:)

[APaule]

yup, there is one:

 

da.FillSchema(tbl, SchemaType.Source)

[hog]

cheers ears!