C# Corner
Tech
News
Videos
Forums
Jobs
Books
Events
More
Interviews
Live
Learn
Training
Career
Members
Blogs
Challenges
Certification
Contribute
Article
Blog
Video
Ebook
Interview Question
Collapse
Feed
Dashboard
Wallet
Learn
Achievements
Network
Refer
Rewards
SharpGPT
Premium
Contribute
Article
Blog
Video
Ebook
Interview Question
Register
Login
.NET
ADO.NET
Android
ASP.NET
C#
Databases & DBA
Design Patterns & Practices
iOS
Java
OOP/OOD
SharePoint
Software Testing
Web Development
WPF
View All
10
Reply
Can we have trigger on DDL statements?
Rahul Chavan
9y
725
0
Reply
Delete Row
Delete Column
Insert Link
×
Insert
Cancel
Embed YouTube Video
×
Width (%)
Height (%)
Insert
Cancel
Table Options
×
Rows
Columns
First row as header
Create Table
Insert Image
×
Selected file:
Alignment
Left
Center
Right
Select an image from your device to upload
Upload to Server
Cancel
Submit
Yes
Mukesh Kumar
8y
0
Yes
Mukesh Kumar
8y
0
Yes
Mukesh Kumar
8y
0
Yes
Mukesh Kumar
8y
0
Yes
Mukesh Kumar
8y
0
Yes
Mukesh Kumar
8y
0
Yes
Mukesh Kumar
8y
0
yes we can use
Shalu Shalini
8y
0
Yes we can have triggers for DDL statements Create TRIGGER [SchemaChange_DDL]ON ALL SERVER FOR CREATE_TABLE, ALTER_TABLE, DROP_TABLE As Begin --Your code End
Vimal Lohani
8y
0
Yes we can have triggers on both DML and DDL statements. These trigger are called as DDL triggers.
Rahul Chavan
9y
0
What is use of NoLock?
What is the use of @@ROWCOUNT statement?
Message