Delete user table dtproperties SQL Server


Is there any consequence of deleting the user table dtproperties of SQL Server ?, I am filtering the permissions of Role Public and verifying that this Role does not have DML and DDL permissions different from the Default ones that point to tables of user since otherwise all users would have those permissions on that table and would have a security failure.

asked by Cristian Zauco 13.12.2017 в 23:51

1 answer


Table dtproperties , along with several objects dt_* are associated with the creation of DER type diagrams from the SQL Enterprise at least until the version of SQL 2000. If we are not interested in maintaining these diagrams, we can do a DROP of the table without more consequence than the loss of these diagrams.

answered by 18.12.2017 / 15:05