34,590
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
y_dong119 2007-06-06
- 打赏
- 举报
都对^_^
chuifengde 2007-05-14
- 打赏
- 举报
if exists(select 1 from syscolumns where id=object_id('表名') and name='列名')
print '存在'
else
print '不存在'
print '存在'
else
print '不存在'
OracleRoob 2007-05-14
- 打赏
- 举报
--用视图：information_schema.columns
if exists (select * from information_schema.columns where table_name='表名' and column_name='列名')
print '存在'
else
print '不存在'
if exists (select * from information_schema.columns where table_name='表名' and column_name='列名')
print '存在'
else
print '不存在'
visualcdotnet 2007-05-14
- 打赏
- 举报
后面一种好像不行啊
visualcdotnet 2007-05-14
- 打赏
- 举报
IF EXISTS (SELECT 1 FROM dbo.syscolumns WHERE [name]='f_zq' AND [id]=OBJECT_ID('tbsc_ddzb'))
print '存在'
else
print '不存在'
if exists (select * from information_schema.columns where table_name='tbsc_ddcb' and column_name='f_zq')
print '存在'
else
print '不存在'
-----
这两种都有效
print '存在'
else
print '不存在'
if exists (select * from information_schema.columns where table_name='tbsc_ddcb' and column_name='f_zq')
print '存在'
else
print '不存在'
-----
这两种都有效
wgsasd311 2007-05-14
- 打赏
- 举报
if exists (select * from syscolumns where table_name='表名' and column_name='列名')
print '存在'
else
print '不存在'
print '存在'
else
print '不存在'
OracleRoob 2007-05-14
- 打赏
- 举报
if exists (select * from information_schema.columns where table_name='表名' and column_name='列名')
print '存在'
else
print '不存在'
cloudtarget 2007-05-14
- 打赏
- 举报
IF EXISTS (SELECT 1 FROM dbo.syscolumns WHERE [name]='列' AND [id]=OBJECT_ID('表'))
