Constraint is used for column Trigger is used for table

What is the difference between constraints and triggers?

Question Posted / rishi kumar

Answer Posted / rishi kumar

Constraint is used for column
Trigger is used for table

Is This Answer Correct ?

23 Yes

7 No

Please Help Members By Posting Answers For Below Questions

Why truncate is ddl command?

1005

How to generate random numbers with the rand() function in ms sql server?

1073

How we create SQL Server 2005 Reporting Services ? Give me Sample

1946

What is merge?

949

What is checkpoint process in the sql server?

975

Can one drop a column from a table?

981

Does partitioning improve performance sql server?

914

What are indexes in sql?

1195

Is sql server a database?

936

Why I am getting this error when renaming a database in ms sql server?

1008

What do you mean by normalisation?

977

what are the different stages of Report Processing?

129

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

866

Explain linked server in sql?

1167

how would you troubleshoot blocking? : Sql server database administration

954