验证数据库对象的创建,例如触发器,过程,权限

问题描述:

我正在创建触发器&Winform应用程序中使用SQL Server 2005 Express的表上的过程.

I am creating triggers & procedures on a table from a winform application which uses sql server 2005 express.

我希望当用户单击创建触发器/过程"按钮时,它会同时创建对象&在触发&的新表单上显示将使用创建它们的名称和表来创建过程.

I want that when the user clicks the create trigger/procedure button, then it creates both the objects & displays on a new Form that triggers & procedures are created with the names and tables on which they are created.

我的意思是我该如何验证对象是否已创建.我想验证并向用户显示在某某某表上创建了对象.

I mean that how do i verify that the objects are created. i want to verify and show it to the user that the objects are created on the so and so table.

创建XXX ... 后,您可以运行 SELECT OBJECT_ID('XXX')

当然,如果您没有错误,则该对象仍然存在

Of course, if you have no error the object exists anyway