MS Sql server查看对象方法（完善中）

MS Sql server 数据库

1.按定义时存储状态分行显示定义（sp_helptext存储过程），调用：Exec sp_helptext '对象名'

2.以表格形式显示返回相关参数(sys.objects视图),调用：select * from sys.objects where name='对象名'

3.作为结果集显示定义（object_definition），调用：select object_definition(object_id('对象名')) as 'aaa'
 可用于下列对象：
  C = Check constraint
  D = Default (constraint or stand-alone)
  P = SQL stored procedure
  FN = SQL scalar function
  R = Rule
  RF = Replication filter procedure
  TR = SQL trigger (schema-scoped DML trigger, or DDL trigger at either the database or server scope)
  IF = SQL inline table-valued function
  TF = SQL table-valued function
  V = View