mysql怎么看表名注释 mysql查看表的备注( 二 )


so.[name] AS ObjectName, so.XType,
(CASE WHEN (LEFT(text, 2) = '/*')
AND (charindex('*/', text)0) THEN substring([text], 3, patindex('%*/%', text) - 3)
ELSE '' END) AS Comments
FROM syscomments AS sc fulljoin sysobjects AS so ON so.[id] = sc.[id]
WHERE so.[xtype] = 'U' OR so.[xtype] = 'V'
mysql表注释查询:
select table_name,table_comment from information_schema.tableswhere table_schema = 'image' and table_name ='tableName'
mysql怎么看表名注释的介绍就聊到这里吧 , 感谢你花时间阅读本站内容,更多关于mysql查看表的备注、mysql怎么看表名注释的信息别忘了在本站进行查找喔 。

推荐阅读