由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - SQL Server Trigger on System Base Table or Catalog View
相关主题
初级问题SQL server stored procedure 求助
SQL问题请教: add one more columnIn MySQL, 如何在procedure里create trigger?谢谢了?
Basic oracle questions.一个single table 的 SQL QUERY
Please help: Innodb table could not drop a columnSQL add some columns into a table from another table (转载
Re: Please help: Innodb table could notSQL combine two columns from two different tables no shared (转载)
Help on Sql server huge table performancedatabase triggers
SQL Developer, how to switch schema?Table Merge (SQL Server)
求救:这个QUERY怎么写in SQL SERVERHow to delete column and row in table
相关话题的讨论汇总
话题: table话题: extended话题: trigger话题: view话题: property
进入Database版参与讨论
1 (共1页)
s**m
发帖数: 1564
1
This is about extended property.
Here is background: when a table/column is created/altered/dropped, extended
properties are inserted/updated/deleted. also table's/column's extended
property can be updated later (not via alter table/column syntax) using
below system procedures (or raw insert/update/delete scripts):
sp_addextendedproperty
sp_updateextendedproperty
sp_dropextendedproperty
Here is my goal: now when an extended property is created/updated/dropped, I
want to fire a trigger which will update a table in another database.
extended property is stored in system base table sys.sysxprops
can trigger be defined on this table?
also extended property can be queried via catalog view sys.extended_
properties
can trigger be defined on this view?
which is better?
please point me to some resources.
Thanks.
1 (共1页)
进入Database版参与讨论
相关主题
How to delete column and row in tableRe: Please help: Innodb table could not
[转载] Can anyone interpret this simple SQL?Help on Sql server huge table performance
How to drop a column from a table in DB2SQL Developer, how to switch schema?
sql server 面试题 (9)求救:这个QUERY怎么写in SQL SERVER
初级问题SQL server stored procedure 求助
SQL问题请教: add one more columnIn MySQL, 如何在procedure里create trigger?谢谢了?
Basic oracle questions.一个single table 的 SQL QUERY
Please help: Innodb table could not drop a columnSQL add some columns into a table from another table (转载
相关话题的讨论汇总
话题: table话题: extended话题: trigger话题: view话题: property