£¨×ª£©ÀûÓà Sql Öв鿴±í½á¹¹ÐÅÏ¢

ת×Ô£ºhttp://hi.baidu.com/cszoo/blog/item/2439a5f517c19c2dbc31093c.html
 
£¨1£©
SELECT
±íÃû=case when a.colorder=1 then d.name else '' end,
±í˵Ã÷=case when a.colorder=1 then isnull(f.value,'') else '' end,
×Ö¶ÎÐòºÅ=a.colorder,
×Ö¶ÎÃû=a.name,
±êʶ=case when COLUMNPROPERTY( a.id,a.name,'IsIdentity')=1 then '√'else '' end,
Ö÷¼ü=case when exists(SELECT 1 from sysobjects where xtype='PK' and parent_obj=a.id and name in (
SELECT name from sysindexes WHERE indid in(
SELECT indid from sysindexkeys WHERE id = a.id AND colid=a.colid
))) then '√' else '' end,
ÀàÐÍ=b.name,
Õ¼ÓÃ×Ö½ÚÊý=a.length,
³¤¶È=COLUMNPROPERTY(a.id,a.name,'PRECISION'),
СÊýλÊý=isnull(COLUMNPROPERTY(a.id,a.name,'Scale'),0),
ÔÊÐí¿Õ=case when a.isnullable=1 then '√'else '' end,
ĬÈÏÖµ=isnull(e.text,''),
×Ö¶Î˵Ã÷=isnull(g.[value],'')
from syscolumns a
left join systypes b on a.xusertype=b.xusertype
inner join sysobjects d on a.id=d.id   and d.xtype='U' and   d.name<>'dtproperties'
left join syscomments e on a.cdefault=e.id
left join sysproperties g on a.id=g.id and a.colid=g.smallid
left join sysproperties f on d.id=f.id and f.smallid=0
--where d.name='Òª²éѯµÄ±í'     --Èç¹ûÖ»²éѯָ¶¨±í,¼ÓÉÏ´ËÌõ¼þ
order by a.id,a.colorder
£¨2£©
SQL2000ϵͳ±íµÄÓ¦ÓÃ
--1£º»ñÈ¡µ±Ç°Êý¾Ý¿âÖеÄËùÓÐÓû§±í
select Name from sysobjects where xtype='u' and status>=0
--2£º»ñȡijһ¸ö±íµÄËùÓÐ×Ö¶Î
select name from syscolumns where id=object_id('±íÃû')
--3£º²é¿´Óëijһ¸ö±íÏà¹ØµÄÊÓͼ¡¢´æ´¢¹ý³Ì¡¢º¯Êý
select a.* from sysobjects a, syscomments b where a.id = b.id and b.text like '%±íÃû%'
--4£º²é¿´µ±Ç°Êý¾Ý¿âÖÐËùÓд洢¹ý³Ì
select name as ´æ´¢¹ý³ÌÃû³Æ from sysobjects where xtype='P'
--5£º²éѯÓû§´´½¨µÄËùÓÐÊý¾Ý¿â
select * from master..sysdatabases D where sid not in(select sid from master..syslogins where name='sa')
»òÕß
select dbid, name AS DB_NAME from master..sysdatabases where sid <> 0x01
--6£º²éѯijһ¸ö±íµÄ×ֶκÍÊý¾ÝÀàÐÍ
select