• We can add constraints on table variable like primary key, unique key and chekc constraints etc.. for eg.:

    DECLARE @MyTable TABLE

    (

    ProductID int primary key IDENTITY(1,1),

    Price money CHECK(Price < 10.0)

    )

    We cannot create non clustered index on table variable also we cannot change the declaration of table variable once created i.e. we cannot alter the table variable.