set table

Database
Enthusiast

set table

can anyone of please explain how it make difference when we declare "set table" while creating a table.
and what its significance.

thanks
Madhavi
2 REPLIES
Enthusiast

Re: set table

SET tables specifies that table cannot have duplicate rows in it.
Enthusiast

Re: set table

There are two types of table creation in Teradta.

SET - It's specifies doesn't allows duplicate rows if its inserting or udating.

MULTISET - Its allows Duplicate rows.