SQL 数据库中所有的用户表,一个表的中的所有列 的SQL
SELECT OBJECT_NAME (id) OBJECT_NAME FROM sysobjects WHERE xtype = 'U' AND OBJECTPROPERTY (id, 'IsMSShipped') = 0
一个表的中的所有列
SELECT a.name from syscolumns a
INNER JOIN sysobjects d on a.id=d.id AND d.xtype='U' AND d.name<>'dtproperties'
WHERE
d.name = '{0}'
一个表的中的所有列
SELECT a.name from syscolumns a
INNER JOIN sysobjects d on a.id=d.id AND d.xtype='U' AND d.name<>'dtproperties'
WHERE
d.name = '{0}'
