SQL Server获取Table Fields Comment说明信息

USE [db_E23]
GO

/****** Object: View [dbo].[View_user_right] Script Date: 2023-02-03 17:33:21 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

DROP VIEW [dbo].[View_uTableInfo]
GO

CREATE VIEW [dbo].[View_uTableInfo] AS
SELECT d.name AS tblName, ISNULL(dbo.Fun_GetStrArrayStrOfIndex(CONVERT(varchar(200), f.value), ’ ‘, 1), ‘’)
AS tblDescription, SUBSTRING(dbo.Fun_GetStrArrayStrOfIndex(CONVERT(varchar(200), f.value), ’ ‘, 2), 1,
PATINDEX(’%[^A-Za-z]%’, dbo.Fun_GetStrArrayStrOfIndex(CONVERT(varchar(200), f.value), ’ ‘, 2)) - 1) AS moduleName,
SUBSTRING(dbo.Fun_GetStrArrayStrOfIndex(CONVERT(varchar(200), f.value), ’ ‘, 2), PATINDEX(’%[^A-Za-z]%’,
dbo.Fun_GetStrArrayStrOfIndex(CONVERT(varchar(200), f.value), ’ ‘, 2)),
LEN(dbo.Fun_GetStrArrayStrOfIndex(CONVERT(varchar(200), f.value), ’ ‘, 2)) - PATINDEX(’%[^A-Za-z]%’,
dbo.Fun_GetStrArrayStrOfIndex(CONVERT(varchar(200), f.value), ’ ', 2)) + 1) AS moduleCnName,
dbo.Fun_GetStrArrayStrOfIndex(CONVERT(varchar(200), f.value), ’ ', 2) AS moduleDescription, a.colorder AS fieldSerialNo,
a.name AS fieldName, CASE WHEN COLUMNPROPERTY(a.id, a.name, ‘IsIdentity’) = 1 THEN 1 ELSE ‘’ END AS logo,
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 1 ELSE ‘’ END AS primaryKey, b.name AS types,
a.length AS bytes, COLUMNPROPERTY(a.id, a.name, ‘PRECISION’) AS fieldLength, ISNULL(COLUMNPROPERTY(a.id,
a.name, ‘Scale’), 0) AS decimalPlace, CASE WHEN a.isnullable = 1 THEN 1 ELSE ‘’ END AS isallowedEmpty, ISNULL(e.text, ‘’)
AS defaultValue, ISNULL(dbo.Fun_GetStrArrayStrOfIndex(CONVERT(varchar(200), g.value), ’ ', 1), ‘’) AS fieldDescription,
ISNULL(dbo.Fun_GetStrArrayStrOfIndex(CONVERT(varchar(200), g.value), ’ ', 2), ‘’) AS fieldComments,
CONVERT(varchar(200), g.value) AS fieldFullcomments
FROM sys.syscolumns AS a LEFT OUTER JOIN
sys.systypes AS b ON a.xtype = b.xusertype INNER JOIN
sys.sysobjects AS d ON a.id = d.id AND d.xtype = ‘U’ AND d.name <> ‘dtproperties’ LEFT OUTER JOIN
sys.syscomments AS e ON a.cdefault = e.id LEFT OUTER JOIN
sys.extended_properties AS g ON a.id = g.major_id AND a.colid = g.minor_id LEFT OUTER JOIN
sys.extended_properties AS f ON d.id = f.major_id AND f.minor_id = 0

GO

最后

以上就是美好路人为你收集整理的SQL Server获取Table Fields Comment说明信息的全部内容，希望文章能够帮你解决SQL Server获取Table Fields Comment说明信息所遇到的程序开发问题。

如果觉得靠谱客网站的内容还不错，欢迎将靠谱客网站推荐给程序员好友。