Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

You can set column and field properties for Entity, Type, and View shapes as follows.

Physical Name column

Type the name of the column.

Data Type column

For the Entity shape, click the type of data that will be entered in the column. For object relational databases, type the complex type.

Req'd column

For the Entity shape, select this check box to specify that the column cannot contain NULL values.

PK column

For the Entity shape, select this check box to specify that the column is a primary key for the table.

This check box is not available for the View and Type shapes.

Add

Click to add a column.

Remove

Click to delete the selected column or columns.

Edit

Click to open the Column Properties dialog box, in which you can set additional options for the selected column.

Move Up

Click to reorder the columns in this list and in your diagram.

Move Down

Click to reorder the columns in this list and in your diagram.

Portable data type

Click to show the data types that are not driver-specific.

Physical data type

Click to show the data type used by the driver you selected.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×