SELECT a.name ColName FROM syscolumns a inner join sysobjects d on a.id=d.id and d.xtype='U' and d.name<>'dtproperties' where d.name='你的数据表名'
select name from syscolumns where id=object_id('tablename')
SELECT syscolumns.name AS columnsname, sysobjects.name AS tablename FROM sysobjects INNER JOIN syscolumns ON sysobjects.id = syscolumns.id WHERE (sysobjects.name = 'Customers')
a.name ColName
FROM syscolumns a
inner join sysobjects d
on a.id=d.id and d.xtype='U' and d.name<>'dtproperties'
where d.name='你的数据表名'
FROM sysobjects INNER JOIN
syscolumns ON sysobjects.id = syscolumns.id
WHERE (sysobjects.name = 'Customers')