在评估表达式时，如何自定义符号的搜索路径？(How can I customize the search path of symbols when evaluating an expression?)

 哪个版本的SQL Server？ 
 
 对于SQL Server 2005及更高版本，您可以获取用于创建视图的SQL脚本，如下所示： 
 
select definition
from sys.objects     o
join sys.sql_modules m on m.object_id = o.object_id
where o.object_id = object_id( 'dbo.MyView')
  and o.type      = 'V'
 
 这将返回一行，其中包含用于创建/更改视图的脚本。 
 
 表中的其他列会说明在编译视图时有关的选项。 
 
 注意事项 
 
 
 
 如果视图最后使用ALTER VIEW进行了修改，那么脚本将是ALTER VIEW语句，而不是CREATE VIEW语句。 
 
 
 该脚本反映了创建的名称。 只有当您执行ALTER VIEW或者使用CREATE VIEW删除并重新创建视图时，才能更新它。 如果视图已被重命名（例如，通过sp_rename ）或所有权已转移到不同的模式，则您返回的脚本将反映原始的CREATE / ALTER VIEW语句：它不会反映当前名称的对象。 
 
 
 一些工具截断输出。 例如，MS-SQL命令行工具sqlcmd.exe会将数据截断为255个字符。 您可以传递参数-y N以获得N字符的结果。 
 

Which version of SQL Server?
 
For SQL Server 2005 and later, you can obtain the SQL script used to create the view like this:
 
select definition
from sys.objects     o
join sys.sql_modules m on m.object_id = o.object_id
where o.object_id = object_id( 'dbo.MyView')
  and o.type      = 'V'
 
This returns a single row containing the script used to create/alter the view.
 
Other columns in the table tell about about options in place at the time the view was compiled.
 
Caveats
 
 
 
If the view was last modified with ALTER VIEW, then the script will be an ALTER VIEW statement rather than a CREATE VIEW statement.
 
 
The script reflects the name as it was created. The only time it gets updated is if you execute ALTER VIEW, or drop and recreate the view with CREATE VIEW. If the view has been renamed (e.g., via sp_rename) or ownership has been transferred to a different schema, the script you get back will reflect the original CREATE/ALTER VIEW statement: it will not reflect the objects current name.
 
 
Some tools truncate the output. For example, the MS-SQL command line tool sqlcmd.exe truncates the data at 255 chars. You can pass the parameter -y N to get the result with N chars.