表类型在哪里存储在sql server中？我们怎样才能重新定义它呢？ [英] Where does the Table Type gets stored in sql server? And how can we redefine it?

问题描述

我正在阅读有关表值参数的内容，这看起来很有趣..但我想知道，当我们在数据库中定义表类型时，它会被保存吗？它的范围是什么？如何修改该类型..假设我创建了一个表类型...

I was reading about Table Value Parameter which seems interesting.. but i want to know that when we define a table type in database where does it get saved? What is its scope? And How can i modify that type .. suppose i created a table type as...

CREATE TYPE DeptType AS TABLE
(
DeptId INT, DeptName VARCHAR(30)
);

现在我怎样才能获得DeptType的架构？如何修改它？

Now how can i get the schema of DeptType in future? How can i modify it?

推荐答案

如果要查看用户定义的数据类型，您必须查询 systypes 或 sys.types table ...

If you want to See the User Defined Data Types u have to Query the systypes or sys.types table...

SELECT * FROM sys.types WHERE is_user_defined = 1
SELECT * FROM systypes WHERE xusertype > 256

用户定义的数据类型无法修改...相反，您必须删除用户定义的数据类型，再次创建它......

检查这个...

修改用户定义的数据类型.. [ ^ ]

dbfriend.net how-to-alter-user-defined-data-type [ ^ ]

这篇关于表类型在哪里存储在sql server中？我们怎样才能重新定义它呢？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！