Versions Compared

Old Version 1

changes.mady.by.user Gamze Kaya

Saved on

compared with

New Version 2

changes.mady.by.user Gamze Kaya

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Wiki Markup
\\
*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