As business demands shift over time, it’s important to adjust how you manage your data as well. Adding new columns to your SQL database tables is a crucial step in maintaining organized and relevant data. By using a simple ALTER TABLE script, you can quickly and easily add new columns to your existing tables.
This post provides a straightforward guide on how to use the ALTER TABLE statement to add a new column to your existing SQL database table. You’ll learn how to specify the name and data type of the new column, as well as a default value if desired, enabling you to update your SQL database tables easily and keep your data organized and relevant to your business needs. So, try out this simple ALTER TABLE script now to keep your data organized and up-to-date.
ALTER TABLE [tablenamehere]
ADD [Name] VARCHAR(100)
--With default value
ALTER TABLE [tablenamehere]
ADD [Name] VARCHAR(100) DEFAULT 'Mr Sample'
ALTER TABLE [tablenamehere]
ADD AGE INT
--With default value
ALTER TABLE [tablenamehere]
ADD AGE INT DEFAULT 0
ALTER TABLE [tablenamehere]
ADD IsActive BIT
--With default value
ALTER TABLE [tablenamehere]
ADD IsActive BIT DEFAULT 0
ALTER TABLE [tablenamehere]
ADD PRICE DECIMAL(10, 2)
--With default value
ALTER TABLE [tablenamehere]
ADD PRICE DECIMAL(10, 2) DEFAULT 0.00;
ALTER TABLE [tablenamehere]
ADD DoB DATE
--With default value
ALTER TABLE [tablenamehere]
ADD DoB DATE DEFAULT '2023-04-13'
