SELECT o.name as tables,c.name as columns,p.value as properties
FROM sysproperties p
join sysobjects o on o.id=p.id
join syscolumns c on p.id=c.id and p.smallid=c.colid
order by 1
FROM sysproperties p
join sysobjects o on o.id=p.id
join syscolumns c on p.id=c.id and p.smallid=c.colid
order by 1
As
SELECT o.name as tables,c.name as columns,p.value as properties
FROM sysproperties p
join sysobjects o on o.id=p.id
join syscolumns c on p.id=c.id and p.smallid=c.colidAnd Then you can use it as fellow:
Select * From v_FieldDesc