SqlServer 获取表或者视图的字段名称、类型等

最新推荐文章于 2023-02-10 14:08:25 发布

明天 ~ ~

最新推荐文章于 2023-02-10 14:08:25 发布

阅读量1.2k

点赞数

分类专栏： Sql 文章标签： sqlserver 数据库 mysql

本文链接：https://blog.csdn.net/qq_45195669/article/details/127531786

版权

Sql 专栏收录该内容

15 篇文章 1 订阅

订阅专栏

CREATE PROCEDURE [dbo].[SysTbStructureView]
(   @TbName NVARCHAR(50))
AS
    SELECT a.name AS ColumnName,
        c.name AS TypeName,
        CASE
            WHEN a.is_nullable = 0 THEN
                'Not Null'
            ELSE
                'Null'
        END AS NullAble
    FROM sys.columns a,
        sys.objects b,
        sys.types c
    WHERE a.object_id = b.object_id
          AND b.name = @TbName
          AND a.system_type_id = c.system_type_id
          AND c.name <> 'sysname'
    ORDER BY a.column_id;

    RETURN;