查出 Table 有哪些欄位

JDP

查詢欄位
select name from syscolumns where id=object_id('TableName')

查詢欄位、型態
SELECT OBJECT_NAME(c.OBJECT_ID) TableName,
c.name AS ColumnName,
t.name AS TypeName
FROM sys.columns AS c
JOIN sys.types AS t ON c.user_type_id = t.user_type_id
WHERE c.OBJECT_ID = (
SELECT id
FROM sysobjects
WHERE XTYPE = 'U' AND NAME = 'TableName'
)

Reference:
http://social.msdn.microsoft.com ... 6-8a7d-97115355ae4b
http://www.programmer-club.com.t ... sqllanguage/46.html