Adding column
You can add new columns to an existing table. .
ALTER TABLE [dbo].[phone]
ADD inactive_date DATETIME NULL
GO
Alter column
You can add modify an existing column
ALTER TABLE [dbo].[person]
ALTER COLUMN [lastname] VARCHAR(35) NULL
GO
Considerations for altering a column
1. Reducing precision (example, going from CHAR(20) to CHAR(15)) can cause data truncation and should be avoided unless you are absolutely sure their will be no impact to the data.
2. Changing data types should typically be avoided. There are exceptions to this. For example, changing a CHAR(20) to a VARCHAR(20) on columns where the average storage length is 10 can save disk space.
Alter columns - No Can Do
You cannot directly alter a a column that is part of the primary key
Saturday, June 28, 2008
Add Column
Labels:
SQL Database,
SQL Server,
SQL Server Tips
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment