Modifying Columns (Visual Database Tools)

To add, change, or delete columns in a table, use Table Designer. In Table Designer, each table column appears as a row in a grid, and the columns of the grid represent the properties of the table column.

To define a table's columns, edit the properties shown in the Column Properties tab in the lower pane of Table Designer. For details about the properties that are available in your database, see your database documentation.


Changing table columns can cause code and applications that depend on the modified column to fail. These include queries, views, stored procedures, user-defined functions, and client applications. Note that these failures will cascade. For example, a stored procedure that calls a user-defined function that depends on the modified column may fail. Carefully consider any changes you want to make to a table column.


If the table is published for replication, you must make schema changes using the Transact-SQL statement ALTER TABLE or SQL Server Management Objects (SMO). When schema changes are made using the Table Designer or the Database Diagram Designer, it attempts to drop and recreate the table. You cannot drop published objects, therefore the schema change will fail.

In This Section