34,576
社区成员
发帖
与我相关
我的任务
分享
SELECT s.definition FROM sys.all_sql_modules AS s WHERE s.[object_id]= OBJECT_ID('view_test')
/*
definition
--------------------------
CREATE VIEW view_test
AS
SELECT 1 AS r;
*/
USE tempdb
GO
IF OBJECT_ID('view_test') IS NOT NULL DROP VIEW view_test
GO
CREATE VIEW view_test
AS
SELECT 1 AS r;
GO
EXEC sp_helptext 'view_test';
/*
Text
------------------------
CREATE VIEW view_test
AS
SELECT 1 AS r;
*/
--用这个试下:
SELECT [text] FROM sys.syscomments AS s WHERE s.id= OBJECT_ID('view_test')
/*
text
------------------------
CREATE VIEW view_test
AS
SELECT 1 AS r;
*/