DEFINITIONS

Definitions More Info.
Definition ID10.064
TitleSQL
CategoryNOTES
DefinitionDisplay the object properties script text- object lerin ozelliklerini gosteren Create scriptini
Definition Descriptionhttps://database.guide/how-objectproperty-works-in-sql-server/
full objeck ozellik listesini gosteren site

Use DPAudit
GO
--Display the scalarFunctions' script text
EXECUTE sp_MSforeachtable
@command1 = 'sp_helptext [?];',
@whereand = 'and OBJECTPROPERTY(o.id, N''IsUserTable'') = 0
/*burada kontrol edilmek istenen ozellikler eklenir */
or OBJECTPROPERTY(o.id, N''IsTableFunction'') = 1'
Go
RecordBycunay
Record Date18-08-2021 12:09:40
Düzenle
Kopyala
Sil