You modify the table by adding new columns to it. You add new columns to tables in the MDT DB using:

·     SQL Server Management Studio. For more information on how to add a column using SQL Server Management Studio, see “How to: Insert Columns into Tables (Visual Database Tools)” in SQL Server Books Online, included with SQL Server.

·     ALTER TABLE Transact-SQL statement. For more information on how to add a column using the ALTER TABLE Transact-SQL statement, see “ALTER TABLE (Transact-SQL)” in SQL Server Books Online, included with SQL Server.

·     Other SQL Server management tools. For more information on how to perform this task using other SQL Server management tools, see the documentation for the corresponding tool.

To add a new column to a table, you need to know:

·     The columns that you will add to the table

·     The SQL data type for each column you will add to the table

·     If the new column allows Null values

·     The default value for the new column (optional)

·     Check constraints for the new column (optional)

For more information on how to determine what to use for each item in the previous list, see the section, “Table Column Properties (SQL Server Management Studio),” in SQL Server Books Online, included with SQL Server.

Example: How Woodgrove Bank Modified Tables

Woodgrove Bank will add a new column to the Settings table called AVServer. The AVServer column will contain the computer name of the antivirus server for each location specified in the LocationIdentity table. Woodgrove Bank has decided to create the AVServer column using the information in Table 196.

Table 196. Information for the AVServer Column

Property

Value

Name

AVServer

Allow Nulls

Yes

Data Type

char(20)

 

Related Topics

Extending the MDT DB Schema