Question : What does GRANT REFERENCES ON TYPE::dbo.myType TO public exactly mean? I found this statement together with every single […]
Temporarily Turn Off Table Type Reference Checking On A Development Database
Question : During my database design process I have begun to add Table Types to the database and have run […]
How to do ALTER TABLE TYPE efficiently
Question : Unlike tables, a table type cannot be altered by a simple command. I need to do the following: […]
I am wanting to use UDTT in my database, but we have CLR turned off, and according to the docs for create type, all types require a CLR assembly
Question : Is this true? Or can I use User defined Table Types with having CLR off? (I.e. they don’t […]
View Default value for User Defined Table Type columns in SQL Server
Question : I have a user defined table type in SQL Server 2014 that I need to drop and recreate. […]
ALTER TYPE Not Available So How To Alter a Type?
Question : I know there are other questions out there regarding this issue, but this one is really simple so […]
SQL Server – Nonclustered Index with Include on User Defined Table Type?
Question : I was working with in-memory User Defined Table Types and got stuck on creating indexes on them. Here’s […]