mysqlºÍsqlserverÖв鿴µ±Ç°¿âÖÐËùÓбíºÍ×Ö¶ÎÐÅÏ¢

>>mysql:
1¡¢²é¿´ËùÓбíÃû£º
show tables [from db_name];
2¡¢²é¿´×Ö¶ÎÐÅÏ¢
SHOW FULL COLUMNS from db_name.table_name
»ñÈ¡ÒÔÏÂÐÅÏ¢
Field £º×Ö¶ÎÃû
Type£º×Ö¶ÎÀàÐÍ
Collation£º×Ö·û¼¯ £¨mysql 5.0ÒÔÉÏÓУ©
Null £ºÊÇ·ñ¿ÉÒÔΪNULL
Key£ºË÷Òý£¨PRI,unique,index)
Default£ºÈ±Ê¡Öµ
Extra£º¶îÍ⣨ÊÇ·ñ auto_increment)
Privileges£ºÈ¨ÏÞ
Comment£º±¸×¢£¨mysql 5.0ÒÔÉÏÓÐ)
>>sqlserver
1¡¢²é¿´ËùÓÐÓû§½¨±íÃû
select name from Sysobjects where xtype='U' order by name;
2¡¢²é¿´×Ö¶ÎÐÅÏ¢
SELECT
a.colorder as ×Ö¶Î˳ÐòºÅ,
a.name as ×Ö¶ÎÃû³Æ,
a.collation as ÅÅÐò×Ö·û¼¯,
ÊÇ·ñ×Ô¶¯Ôö³¤Êý×Ö=case when COLUMNPROPERTY( a.id,a.name,'IsIdentity')=1 then 'yes'else 'no' end,
ÊÇ·ñÖ÷¼ü=case when exists(SELECT 1 from sysobjects where xtype='PK' and name in (
SELECT name from sysindexes WHERE indid in(
SELECT indid from sysindexkeys WHERE id = a.id AND colid=a.colid
))) then 'yes' else 'no' end,
×Ö¶ÎÀàÐÍ=b.name,
×ֶ㤶È=a.length,
×Ö¶Î×Ö·û³¤¶È=COLUMNPROPERTY(a.id,a.name,'PRECISION'),
СÊýλÊý=isnull(COLUMNPROPERTY(a.id,a.name,'Scale'),0),
ÊÇ·ñΪNULL=case when a.isnullable=1 then 'yes'else 'no' end,
ȱʡֵ=isnull(e.text,'')
from syscolumns a
left join systypes b on a.xtype=b.xusertype
inner join sysobjects d on a.id=d.id and (d.xtype='U' or d.xtype='V') and d.name<>'dtproperties'
left join syscomments e on a.cdefault=e.id
where d.name='purchase_medicine'
order by a.colorder