DEFINITIONS
Definitions More Info.
Definition ID
10.061
Title
SQL
Category
NOTES
Definition
Display the views script text -view Create scirptlerini olusturur
Definition Description
https://www.mssqltips.com/sqlservertip/1905/iterate-through-sql-server-database-objects-without-cursors/
Script #3 using sp_MSForEachTable icinde mevcut
--Display the views' script text
EXECUTE sp_MSforeachtable
@command1 = 'sp_helptext [?];',
@whereand = 'and OBJECTPROPERTY(o.id, N''IsUserTable'') = 0
or OBJECTPROPERTY(o.id, N''IsView'') = 1'
Go
RecordBy
cunay
Record Date
18-08-2021 12:02:54
Düzenle
Kopyala
Sil