2,496
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
swayi21 2003-05-15
- 打赏
- 举报
exec sp_columns tAttendance
foreveryday007 2003-05-15
- 打赏
- 举报
//TTable,TTQuery
for i := 0 to FieldDefs.Count - 1 do
begin
sTmp := FieldDefs.Items[i].Name;//DataType,Size,Required
for i := 0 to FieldDefs.Count - 1 do
begin
sTmp := FieldDefs.Items[i].Name;//DataType,Size,Required
dingzhongfeng 2003-05-15
- 打赏
- 举报
select b.name AS 字段,
c.name as 数据类型 ,
b.length as 长度,
case b.isnullable when 0 then 'not null' when 1 then 'null'end as 是否为空
from sysobjects a,syscolumns b,systypes c
where a.name='表名' and a.id = b.id and b.usertype=c.usertype
order by colid
c.name as 数据类型 ,
b.length as 长度,
case b.isnullable when 0 then 'not null' when 1 then 'null'end as 是否为空
from sysobjects a,syscolumns b,systypes c
where a.name='表名' and a.id = b.id and b.usertype=c.usertype
order by colid
zhaojiansheng 2003-05-15
- 打赏
- 举报
SELECT b.*
FROM sysobjects a,syscolumns b
where a.id=b.id
and a.name='表名'
FROM sysobjects a,syscolumns b
where a.id=b.id
and a.name='表名'
goldencity 2003-05-15
- 打赏
- 举报
sp_help TableName
