Page History

Wiki Markup\\ *SQL'de* *Tablo / Store Procedure SP / View / Trigger Listeleme* \\ *Tablo İçin :* \\

SELECT TABLE_NAME NAME  FROM INFORMATION_SCHEMA.TABLES --{*}(view dahil)* \\

SELECT TABLE_NAME 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 )

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