In our work, not all of us have Visio and other database design software. We often directly design the database in the SQL Enterprise Manager, and then add the database dictionary, to facilitate future work and management. Sometimes I am very upset because we have to describe the data fields twice, which is troublesome.
However, not all of this. Not long ago, I found a better method: (take creating a table as an example)
1. Open the Enterprise Manager.
2. Right-click the link and create a new link. Select cancel when you select a table.
3. Right-click the link, select new table, and enter the name we want. (Is the method different from the traditional one)
4. Right-click the newly created table, and then select "Table View" and "Modify custom settings ".
5. Select the columns we want in the pop-up dialog box.
6. OK.
7. Of course, we enter the data table structure and description in our minds. When we want to generate the data table dictionary, We will select these columns, CTRL + C, then go to excel and press Ctrl + v. If you want to export word, select the desired cell in Excel, and press Ctrl + C to press Ctrl + V in word.
8. Of course it is OK! Let's take a look at our results!