-
Read table description into ADODB.Recordset.
How do I read the Tables description into ADODB.Recordset and then recreate the Tables+description into a new database from the ADODB.Recordset.
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|