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 …

Jun 2, 2011 · Exec sp_describe_first_result_set @tsql= N'Select * from <yourtable>' If you enter a complex select statement (joins, subselects, etc), it will give you the definition of the result set. …

Jan 20, 2017 · Edit: I noticed it would regenerate the whole definition every time the UI page was viewed (which could be crippling in your scenario). Fortunately it's super easy to cache this …

May 23, 2023 · OpenAPI Specification has a similar (but not quite the same) concept where you can define multiple API servers within the same API definition. – Helen Commented May 23, …

Feb 8, 2014 · Select object_definition(object_id) from sys.objects where type_desc in ( 'SQL_STORED_PROCEDURE') I can display script of all store procedure. Question 1 : I have …

SELECT ROUTINE_NAME FROM information_schema.routines WHERE routine_type = 'function' but I can't think of or find a way to feed the ROUTINE_NAME list to the OBJECT_ID. The …

Mar 15, 2015 · This query will retrieve the textual definition of stored procedures and filter using a simple wildcard. For 2000 (untested, but IIRC it's the right table):

Aug 13, 2019 · 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.VW_myname') and o.type = 'V' My question is …

This query should show you all the constraints on a table: select chk.definition from sys.check_constraints chk inner join sys.columns col on chk.parent_object_id = col.object_id …

Oct 24, 2013 · select table_name, column_name, data_type, data_length, data_precision, nullable from USER_TAB_COLUMNS where table_name = '<table_name>'; This is only an example …