Getting all the Database objects i.e. Table definitions,Views,Triggers,Procedures.

vishalneeraj-24503
Posted by vishalneeraj-24503 under Sql Server category on | Points: 40 | Views : 909
sys.sql_modules contain all the table definition,views,stored procedure,triggers.
Write below query:-
SELECT 
OBJECT_NAME(object_id) as Object_Name,
definition as Object_Definition
FROM sys.sql_modules;

Comments or Responses

Login to post response