These are sql query using to sear records about procedure ,function ,tables..etc without using UI.

These are sql query using to sear records about procedure ,function ,tables..etc without using UI.

exec dbo.Search_data12 1

----------to searching stored procedure without UI.-------------
-------steps-1-execute stored proc
-------------2-tools--select sqlproplier--select sp--run---erase-

-------sp_helptext Search_data12--copy table ----paste-see
sp_helptext Search_data12

CREATE proc [dbo].[Search_data12]
 @rollno int
 as
 begin
  select stud_name, std_course from tbl_studentRecords where @rollno=rollno
 end

 --------------------to see all tables in database----------
 select * from sys.tables ----where type='U'
 select * from sys.procedures -----to procedures
-----------------------------------------------------------

select * from INFORMATION_SCHEMA.TABLES where TABLE_NAME='tbl_studentRecords'-------
select * from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME='tbl_studentRecords'-------

---------------------------------------------------------------for functions--
select * from INFORMATION_SCHEMA.ROUTINES where ROUTINE_TYPE='function name'
select * from INFORMATION_SCHEMA.ROUTINES where ROUTINE_TYPE='Search_data12'