获取数据库中,所有用户表中每一列名和其数据类型。 SELECT OBJECT_NAME(c.OBJECT_ID) AS [Table_Name], c.[name] AS [Column_Name] ,t.[na
获取数据库中,所有用户表中每一列名和其数据类型。
SELECT OBJECT_NAME(c.OBJECT_ID) AS [Table_Name], c.[name] AS [Column_Name] ,t.[name] AS [Data_Type_Name]
FROM sys.columns AS c
LEFT JOIN SYSOBJECTS AS s ON (c.[object_id] = s.[id])
LEFT JOIN sys.types AS t ON (c.[user_type_id]=t.[user_type_id])
WHERE s.xtype = "U"
Source Code
--结束END--
本文标题: 获取数据库中用户表所有列和列的数据类型
本文链接: https://www.lsjlt.com/news/3534.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑,方便收藏和打印~
2024-05-10
2024-05-10
2024-05-10
2024-05-10
2024-05-10
2024-05-10
2024-05-09
2024-05-09
2024-05-09
2024-05-09
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
0