The table column properties can be found at the bottom pane of Table Designer. Moreover, you can edit the properties in the Properties window when the column is selected. Table Column Properties\u00a0can be displayed in categories or alphabetically. Also, it must be noted that many properties only appear or can only be changed for specific data types. Remember, when the table is published for replication, you must make schema changes using the Transact-SQL statement\u00a0ALTER TABLE\u00a0or SQL Server Management Objects (SMO).\u00a0<\/p>\n\n\n\n
Elements of Table column Properties<\/strong><\/h4>\n\n\n\n
Features<\/strong><\/td>
Description<\/strong><\/td><\/tr>
General<\/strong><\/td>
It is used to Expands to show\u00a0Name<\/strong>,\u00a0Allow Nulls<\/strong>,\u00a0Data Type<\/strong>,\u00a0Default Value or Binding<\/strong>,\u00a0Length<\/strong>,\u00a0Precision<\/strong>, and\u00a0Scale<\/strong>.<\/td><\/tr>
Name<\/strong><\/td>
It helps display the name of the selected column.<\/td><\/tr>
Allow Nulls<\/strong><\/td>
It indicates whether this column allows nulls. To edit this property, click the Allow Nulls checkbox corresponding to the column in the top pane of Table Designer.<\/td><\/tr>
Data Type<\/strong><\/td>
It is used to display the data type for the selected column. To edit this property, click its value, expand the drop-down list, and choose another value.<\/td><\/tr>
Default Value or Binding<\/strong><\/td>
It displays the default for this column whenever no value is specified for this column.\u00a0<\/td><\/tr>
Length<\/strong><\/td>
Shows the number of characters allowed for character-based data types. Only available for character-based data types<\/td><\/tr>
Scale<\/strong><\/td>
It displays the maximum number of digits that can appear to the right of the decimal point for values of this column.<\/td><\/tr>
Precision<\/strong><\/td>
It displays the maximum number of digits for values in this column.\u00a0<\/td><\/tr>
Table Designer<\/strong><\/td>
It helps to expand the\u00a0Table Designer<\/strong>\u00a0section.<\/td><\/tr>
Collation<\/strong><\/td>
It displays the collating sequence that SQL Server applies by default to the column whenever the column values are used to sort rows of a query result.<\/td><\/tr>
Computed Column Specification<\/strong><\/td>
It displays information about a computed column.<\/td><\/tr>
Condensed Data Type<\/strong><\/td>
It displays information about the field’s data type, in the same format as the SQL CREATE TABLE statement.\u00a0<\/td><\/tr>
Description<\/strong><\/td>
It displays text describing this column.<\/td><\/tr>
Deterministic<\/strong><\/td>
It displays whether the data type of the selected column can be determined with certainty.<\/td><\/tr>
DTS-published<\/strong><\/td>
It displays whether the column is DTS-published.\u00a0<\/td><\/tr>
Full-text Specification<\/strong><\/td>
It displays information about a full-text index.\u00a0The value of this property is the value of the\u00a0Is Full-text Indexed<\/strong>\u00a0child property and indicates whether this column is full-text indexed.<\/td><\/tr>
Statistical Semantics<\/strong><\/td>
It selects whether to enable statistical semantic indexing for the selected column.\u00a0<\/td><\/tr>
Has Non-SQL Server Subscribe<\/strong>r<\/td>
It indicates if the column is being replicated to a subscriber that is not a SQL Server.<\/td><\/tr>
Identity Specification<\/strong><\/td>
It displays information about whether and how this column enforces uniqueness on its values.<\/td><\/tr>
Indexable<\/strong><\/td>
It displays whether the selected column can be indexed.<\/td><\/tr>
Merge-published<\/strong><\/td>
It displays whether the column is merge-published.<\/td><\/tr>
Not For Replication<\/strong><\/td>
It indicates whether original identity values are preserved during replication.\u00a0<\/td><\/tr>
Replicated<\/strong><\/td>
It displays whether this column is replicated in another location.<\/td><\/tr>
RowGuid<\/strong><\/td>
It indicates whether SQL Server uses the column as a ROWGUID. You can set this value to\u00a0Yes<\/strong>\u00a0only for a unique identity column.\u00a0<\/td><\/tr>
Size<\/strong><\/td>
It displays the size in bytes allowed by column’s data type.\u00a0<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
![\"Microsoft](\"https:\/\/www.testpreptraining.ai\/tutorial\/wp-content\/uploads\/2021\/01\/Microsoft-Exam-DA-100-Free-Practice-Test.png\")
<\/a><\/figure><\/div>\n","protected":false},"excerpt":{"rendered":"