Read table description into ADODB.Recordset.

[Torex88]

How do I read the Tables description into ADODB.Recordset and then recreate the Tables+description into a new database from the ADODB.Recordset.

[MAK]

I believe you are talking about column description. All the descriptions of columns are stored in sysproperties table.



--Active is the table name
select value from sysproperties where id in (select id from sysobjects where name= 'active')

--To get values with column names
select b.name,c.name,a.value from sysproperties a,sysobjects b,syscolumns c
where b.name ='active' and a.id=b.id and
a.id=c.id and a.smallid = c.colorder