Page History
\\
*SQL'de* *Tablo / Store Procedure SP / View / Trigger Listeleme*
\\
*Tablo İçin :*
\\
Wiki Markup
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