DEFINITIONS

Definitions More Info.
Definition ID10.061
TitleSQL
CategoryNOTES
DefinitionDisplay the views script text -view Create scirptlerini olusturur
Definition Descriptionhttps://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
RecordBycunay
Record Date18-08-2021 12:02:54
Düzenle
Kopyala
Sil