(SELECT indid
WHERE indid IN
sysproperties f ON d.id = f.id AND f.smallid = 0
sysobjects d ON a.id = d.id AND d.xtype = 'U' AND
WHERE (b.name = 'keyfactory') AND (c.status <> '1')

复制代码 代码如下:

'IsIdentity') = 1 THEN '1' ELSE '0' END AS 'identity', a.name AS ColName, c.name AS TypeName, a.length AS 'byte', COLUMNPROPERTY(a.id, a.name,
(SELECT 1
(SELECT 1
WHERE indid IN
sysproperties g ON a.id = g.id AND a.colid = g.smallid LEFT OUTER JOIN
sys.sysobjects AS b ON a.id = b.id INNER JOIN
(SELECT indid
WHERE id = a.id AND colid = a.colid)))
'IsIdentity') = 1 THEN '1' ELSE '0' END AS 'identity', a.name AS ColName, c.name AS TypeName, a.length AS 'byte', COLUMNPROPERTY(a.id, a.name,
sys.systypes AS c ON a.xtype = c.xtype LEFT OUTER JOIN
--b.name = 'Keyfactory','Keyfactory'为你想要查找的数据表。
a.length AS 占用字节数, COLUMNPROPERTY(a.id, a.name, 'PRECISION') AS 长度,

SELECT CASE WHEN EXISTS
(SELECT indid
syscomments e ON a.cdefault = e.id LEFT OUTER JOIN
(SELECT name
FROM sysindexes
sys.extended_properties AS p ON a.id = p.major_id AND a.colid = p.minor_id
WHERE id = a.id AND colid = a.colid))) THEN '1' ELSE '0' END AS 'key', CASE WHEN COLUMNPROPERTY(a.id, a.name,
d.name <> 'dtproperties' LEFT OUTER JOIN
WHERE indid IN
FROM sysindexkeys
'') AS 字段说明
(SELECT 1
FROM syscolumns a LEFT OUTER JOIN
'PRECISION') AS 'length', a.xscale, a.isnullable, ISNULL(e.text, '') AS 'default', ISNULL(p.value, '') AS 'comment'
-- SQL Server 2000
FROM sys.syscolumns AS a INNER JOIN
--2、SQL SERVER 2005
--b.name = 'Keyfactory','Keyfactory'为你想要查找的数据表。
FROM sysindexkeys
(SELECT name
systypes b ON a.xusertype = b.xusertype INNER JOIN
WHERE (b.name = 'keyfactory') AND (c.status <> '1')
FROM sysindexes
WHERE id = a.id AND colid = a.colid))) THEN '1' ELSE '0' END AS 'key', CASE WHEN COLUMNPROPERTY(a.id, a.name,
FROM sysindexkeys
sys.systypes AS c ON a.xtype = c.xtype LEFT OUTER JOIN
WHERE xtype = 'PK' AND parent_obj = a.id AND name IN
'PRECISION') AS 'length', a.xscale, a.isnullable, ISNULL(e.text, '') AS 'default', ISNULL(p.value, '') AS 'comment'
a.xscale AS 小数, a.isnullable AS 可空, ISNULL(e.text, '') AS 默认值, ISNULL(g.[value],
WHERE xtype = 'PK' AND parent_obj = a.id AND name IN
THEN '1' ELSE '0' END AS 主键, CASE WHEN COLUMNPROPERTY(a.id, a.name,
SELECT CASE WHEN EXISTS
'IsIdentity') = 1 THEN '1' ELSE '0' END AS 标识, b.name AS 类型,
(SELECT name
FROM sys.syscolumns AS a INNER JOIN
SELECT a.name AS 字段名, CASE WHEN EXISTS
WHERE xtype = 'PK' AND parent_obj = a.id AND name IN
sys.syscomments AS e ON a.cdefault = e.id LEFT OUTER JOIN
FROM sysobjects
sys.extended_properties AS p ON a.id = p.major_id AND a.colid = p.minor_id
FROM sysindexes
sys.syscomments AS e ON a.cdefault = e.id LEFT OUTER JOIN
FROM sysobjects
FROM sysobjects
WHERE (d.name = '表名称')
--2。SQL SERVER 2005

sys.sysobjects AS b ON a.id = b.id INNER JOIN