34,576
社区成员
发帖
与我相关
我的任务
分享
/*
获取一个表的列名
(爱新觉罗.毓华 2008-01-02 广东深圳)
*/
--sql server 2005的写法
SELECT column_name
FROM INFORMATION_SCHEMA.columns
WHERE table_name = 'Employee'
/*
column_name
----------------
EmployeeID
NationalIDNumber
ContactID
LoginID
ManagerID
Title
BirthDate
MaritalStatus
Gender
HireDate
SalariedFlag
VacationHours
SickLeaveHours
CurrentFlag
rowguid
ModifiedDate
(16 行受影响)
*/
--sql server 2000 的写法
select col_name(object_id('authors'),ordinal_position)
from information_schema.columns
where table_name = 'authors'
/*
---------
au_id
au_lname
au_fname
phone
address
city
state
zip
contract
(所影响的行数为 9 行)
*/