create table tb(id int,name varchar(10))SELECT c.name,t.name FROM sysobjects o,syscolumns c,systypes t WHERE o.id=c.id AND OBJECTPROPERTY(o.id,N'IsUserTable')=1 AND c.xusertype=t.xusertype AND o.name='tb'name name id int name varchar
create table tb(id int,name varchar(10)) SELECT c.name,t.name FROM sysobjects o,syscolumns c,systypes t WHERE o.id=c.id AND OBJECTPROPERTY(o.id,N'IsUserTable')=1 AND c.xusertype=t.xusertype AND t.name='varchar' AND o.name='tb'name name name varchar
select o.name,c.name,s.name from sysobjects o join syscolumns c on o.id=c.id and o.xtype='U' and o.name='authors' --这里换你的表名 join systypes s on c.xtype=s.xtype and s.name='char'
create table tb(id int,name varchar(10)) SELECT c.name,t.name FROM sysobjects o,syscolumns c,systypes t WHERE o.id=c.id AND OBJECTPROPERTY(o.id,N'IsUserTable')=1 AND c.xusertype=t.xusertype AND t.name='varchar' AND o.name='tb' 系统表查
2000好像是 select name from syscolumns where object_id('table')=id where xtype= 175
+上长度呢?nvarchar长度为100的
select o.name,c.name,s.name from sys.objects o join sys.columns c on o.object_id=c.object_id and o.type='U' and o.name='authors' join sys.types s on c.user_type_id=s.user_type_id and s.name='char'
select o.name,c.name,s.name ,c.* from sys.objects o join sys.columns c on o.object_id=c.object_id and o.type='U' and o.name='authors' and max_length=12 --写上表名,长度 join sys.types s on c.user_type_id=s.user_type_id and s.name='char'
FROM sysobjects o,syscolumns c,systypes t
WHERE o.id=c.id
AND OBJECTPROPERTY(o.id,N'IsUserTable')=1
AND c.xusertype=t.xusertype
AND o.name='tb'name name
id int
name varchar
SELECT c.name,t.name
FROM sysobjects o,syscolumns c,systypes t
WHERE o.id=c.id
AND OBJECTPROPERTY(o.id,N'IsUserTable')=1
AND c.xusertype=t.xusertype
AND t.name='varchar'
AND o.name='tb'name name
name varchar
from sysobjects o
join syscolumns c
on o.id=c.id and o.xtype='U' and o.name='authors' --这里换你的表名
join systypes s
on c.xtype=s.xtype and s.name='char'
系统表查
select name from syscolumns
where object_id('table')=id
where xtype= 175
from sys.objects o
join sys.columns c
on o.object_id=c.object_id and o.type='U' and o.name='authors'
join sys.types s
on c.user_type_id=s.user_type_id and s.name='char'
from sys.objects o
join sys.columns c
on o.object_id=c.object_id and o.type='U' and o.name='authors' and max_length=12 --写上表名,长度
join sys.types s
on c.user_type_id=s.user_type_id and s.name='char'