search

Home >Database >Mysql Tutorial >查看表字段信息

查看表字段信息

WBOY
WBOYOriginal
2016-06-07 14:56:471156browse

查看表字段信息 无 select c.colid, c.name, c.xtype, c.length, xprecfrom syscolumns cinner join sysobjects o on o.id=c.idwhere o.name='INVMA'order by colid

查看表字段信息 

select c.colid, c.name, c.xtype, c.length, xprec
from syscolumns c
inner join sysobjects o on o.id=c.id
where o.name='INVMA'
order by colid
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：SQL with rollup 、with cube、grouping 统计函数用法Next article：SQL With Ties 用法

Related articles

See more