create table dbo.TransactionTypes
(
  transaction_type_id int not null primary key clustered,
  transaction_type_description varchar(256) not null
)

alter table tbl_tranasaction
with check add constrain FK_Transaction_TransactionType foreign key(TransactionType)
references TransactionTypes(transaction_type_id)

quote:

---

Originally posted by sunitabeck

You can create a reference table that lists all the transaction types - for example like this:

create table dbo.TransactionTypes
(
  transaction_type_id int not null primary key clustered,
  transaction_type_description varchar(256) not null
)

Then insert all the possible transaction types with an integer id and a description into that table.

You may also want to add a foreign key constraint on the tbl_transaction to refer to this newly created table, like this:

alter table tbl_tranasaction
with check add constrain FK_Transaction_TransactionType foreign key(TransactionType)
references TransactionTypes(transaction_type_id)

---