Sql

Search

sql server find all referencing objects to user-defined table type

-- Find all referencing objects to user-defined table type
SELECT ROW_NUMBER() OVER (ORDER BY OBJECT_NAME(m.object_id)) RowId, definition
FROM sys.sql_expression_dependencies d
JOIN sys.sql_modules m ON m.object_id = d.referencing_id
JOIN sys.objects o ON o.object_id = m.object_id
WHERE referenced_id = TYPE_ID('NAME_OF_TABLE_TYPE')

Comment

PREVIOUS	NEXT

Code Example
Sql :: oracle ora-00054 how to unlock
Sql :: back up stored procedures mysql
Sql :: mysql date time string format for marshmellow field schema
Sql :: ORACLE CALL BACK TRACE
Sql :: sql trying to delete database in use
Sql :: postgresql find blocked query
Sql :: oracle compile trigger
Sql :: get last record deluge
Sql :: select where mysql
Sql :: querry mysql by 2 columns
Sql :: SQLSTATE[42000]: Syntax error or access violation: 1140 Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
Sql :: tsql find procedure with name
Sql :: sql query order
Sql :: sql field equals multiple values
Sql :: mssql default connection string
Sql :: xml to column sql
Sql :: homebrew mysql service not starting
Sql :: check constraint in ms sql
Sql :: linux upload database to mysql
Sql :: Truncate a table then insert data
Sql :: window function sql
Sql :: sql into
Sql :: postgres insert new row advance count
Sql :: rename view mysql
Sql :: delete sql
Sql :: sql order by clause
Sql :: postgres execute multiple sql file from command line
Sql :: mysql write into table
Sql :: can i use alias in where clause
Sql :: mysql replace empty string with null

Search

SQL

sql server find all referencing objects to user-defined table type

ADD CONTENT