SQL Tablo - Store Procedure - View - Trigger Listeleme

--Tablo Sorgulama:

Select TABLE_NAME from INFORMATION_SCHEMA.TABLES --(view dahil)

Select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME not LIKE '%LV%' --(view hariç)

--Stored Procedure Sorgulama:

Select [NAME] from sysobjects where type = 'P' and category = 0

--Views Sorgulama:

Select [NAME] from sysobjects where type = 'V' and category = 0

--Triggers Sorgulama:

Select * from sys.triggers