Stored Procedure / Table Name in Sql Server

Stored Procedure / Table Name in Sql Server

Find Stored Procedure / Table Name in Sql Server

Following query is used

Select * FROM sys.objects 

where type = 'P'  AND Name LIKE '%StoredProcedureName%'

order by create_date desc

• For finding Table / View / User Defined Function you can refer following table.

Type	Type_Desc
D	DEFAULT_CONSTRAINT
F	FOREIGN_KEY_CONSTRAINT
FN	SQL_SCALAR_FUNCTION
IF	SQL_INLINE_TABLE_VALUED_FUNCTION
IT	INTERNAL_TABLE
P	SQL_STORED_PROCEDURE
PK	PRIMARY_KEY_CONSTRAINT
S	SYSTEM_TABLE
SQ	SERVICE_QUEUE
TF	SQL_TABLE_VALUED_FUNCTION
U	USER_TABLE
UQ	UNIQUE_CONSTRAINT
V	VIEW