Asp.net modules
  • Home
  • c# Modules
  • Web Design
    • Html
    • Css
    • Java Script
  • Bootstrap
  • Sql
    • Queries
    • Stored Procedures
  • About Me
    • About Myself
    • My Projects
    • My Resume
  • Photo Gallery

Wednesday, January 18, 2017

How to get all tables, Procedures, triggers, objects name in SQL server

 Unknown     2:17 AM     tables     No comments   

Intoduction :-
Hii Friends...

This is an easy way to find tables, procedures, triggers which was made by you or your friends and you don't know the table or procedures name then you can simply fire below queries
with remember name like if your table name is tbl_Employee and procedure name is proc_ManageEmployee and trigger name is tgr_updateEmployee then you can fire query like below queries

1. for tables :  select * from sys.tables where name like '%Employee%'
you will get tbl_Employee  as result.
2. for procedures :  select * from sys.procedures where name like '%Employee%'

you will get proc_ManageEmployee as result.
3. for triggers :  select * from sys.triggers where name like '%Employee%'

you will get tgr_updateEmployee as result.

you can also put your own condition with these conditions like AND Id > 10 OR Mobile=123456789

Thank You !
  • Share This:  
  •  Facebook
  •  Twitter
  •  Google+
Email ThisBlogThis!Share to XShare to Facebook
Newer Post Older Post Home

0 comments:

Post a Comment

Popular Posts

  • How to make color picker
    Intoduction :-   Hii Friends... Today i going to put a very interesting module i.e how to make a color picker module. Its very interesti...
  • Angular Directives
    Intoduction :-   Hii Friends... Today I explain about Angular Directives.  1) Angular JS use new attribute i.e called Directives. 2)...
  • Asp.net insert, Edit, update, delete in grid view
    Introduction :   Here I explain how to insert, edit, update and delete data in grid view using asp.net. In this project I use so...
  • Bounce a circle with Css
    Intoduction :-   Hii Friends... Today I explain how to make a bouncing circle with the help of css.  DEMO:- ...
  • Bootstrap Model
      Intoduction :-   Hii Friends... Today I explain how to make a bootstrap model in asp.net . Its not so complicated its easy. here som...
  • How To Make A Calculator In Html
    Intoduction :- Hii Friends... Today I explain how to make a calculator with html. So here i explain this step by step. Step : 1    Th...
  • Calculator with Angular JS
    Intoduction :-   Hii Friends... Today I explain how to make a Calculator with the help of Angular JS. In this code i use some directive...
  • Angular Js Introduction
    Intoduction :-   Hii Friends... Today I explain about angular js. Angular js is a part of javascript but its extended. 1 ) AngularJS ...
  • How To Make Semi-Transparent Buttons
    Intoduction :-   Hii Friends...   Today I explain how to make Semi-Transparent Buttons with the help of css. This style now a days goes t...
  • How To Make A Timer With JavaScript
    Introduction :- Hii Friends.. Today I explain how to make a timer with a popup message with the help of Java-Script. At the end when tim...

Blog Archive

  • ▼  2017 (13)
    • ►  December (1)
    • ►  March (5)
    • ►  February (1)
    • ▼  January (6)
      • CSS3 image and List hover effects
      • CSS3 image and text hover effects
      • CSS3 image hover effects
      • jQuery image slider with three panels and 3D look
      • How to get all tables, Procedures, triggers, objec...
      • How To scroll from bottom to top
  • ►  2016 (31)
    • ►  November (1)
    • ►  September (1)
    • ►  June (6)
    • ►  May (3)
    • ►  April (2)
    • ►  March (8)
    • ►  February (9)
    • ►  January (1)
  • ►  2015 (31)
    • ►  December (3)
    • ►  November (4)
    • ►  October (18)
    • ►  September (6)

About Me

Unknown
View my complete profile

Copyright © Asp.net modules | Powered by Blogger
Design by Sheetal Khandelwal