SQL'de Tablo / Store Procedure SP / View / Trigger Listeleme
Tablo İçin :
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 İçin :
Select [NAME] from sysobjects where type = 'P' and category = 0
Views İçin :
Select [NAME] from sysobjects where type = 'V' and category = 0
Triggers İçin:
select * from sys.triggers