SQL’de Tablo, Store Procedure SP, View ve Trigger Listeleme Komutları

SQL’de Tablo, Store Procedure SP, View ve Trigger Listeleme Komutları

768 Görüntülenme
0
0

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

Yorum Yap

Kategoriler