Which of the following statements are correct about table variable?
The following statement will not work.
select * into @tablevariable from source_table;
Foreign key constraint is not
allowed in the declaration of table variable.
Primary key, not null,check, default and unique constraints are allowed in table variable declaration .
All the options are correct.
Back To Top