CODEWITHSUNDEEP
databaseumlvisio
anh
anh

Reputation: 81

What does I1, I2, U1, means in Visio database relationship diagram?

I am reverse engineering an database to create an database ER diagram in Visio. When I display the table in Visio, on the left hand side of the entity diagram, I see symbols next to the column names that I do not know what they mean. Symbols such as, U1, U2, l1, l2, l5...etc. Others symbols such as PK (primary key) and FK (foreign key) are also shown in the same area, but those obviously make sense to me.

Upvotes: 8

Views: 11484

Answers (1)

JStead
JStead

Reputation: 1730

These are other types of indexes.

U1 = Unique Index 1..... I1 = Index 1......

Here are examples in SQL Server http://msdn.microsoft.com/en-us/library/ms188783.aspx

Upvotes: 13

Related Questions