Need help!!!

[eng sh]

Hi

Please I need your help.. I'm a beginner in SQL server 2005..

I have tables a, b, c, d. Each table has different number of fields, and the fields names' are abbreviated names.

1) I want to make a description look up table. This table contains two columns. The first column is for the abbreviated name of the tables (a, b, c, d). The second column is for the description of the table name.

2) Also, I want to make a field look up table. This table contains two columns. The first column is for the abbreviated name of the field, the second column is for the description of the field name.

How can I do that??

Thanks in advance

[rmiao]

Why don't just name tables and columns with meaningful name?

[eng sh]

Why don't just name tables and columns with meaningful name?

The meaningful names are very very long.. I have to use abbreviations..

[rmiao]

Then you have to build those lookup tables manually.

[eng sh]

Ok.. thanks alot