Collections:
"ALTER TABLE ... ADD" - Adding New Columns to Existing Tables in SQL Server
How To Add a New Column to an Existing Table with "ALTER TABLE ... ADD" in SQL Server?
✍: FYIcenter.com
If you have an existing table with existing data rows, and want to add a new column to that table, you can use the "ALTER TABLE ... ADD" statement. The tutorial script below shows you a good example:
ALTER TABLE tip ADD author VARCHAR(40) GO sp_columns tip GO TABLE_OWNER TABLE_NAME COLUMN_TABLE TYPE_NAME ... dbo tip id int ... dbo tip subject varchar ... dbo tip description varchar ... dbo tip create_date datetime ... dbo tip author datetime ... SELECT * FROM tip GO id subject description create_date author 1 Learn SQL Visit dev.fyicenter.com 2006-07-01 NULL
This SQL script added a new column called "author" to the "tip" table. NULL values were added to this column on all existing data rows.
⇒ "ALTER TABLE ... DROP COLUMN" - Deleting Existing Columns in SQL Server
⇐ "SELECT ... INTO" - Creating New Tables With Queries in SQL Server
2016-11-17, 1931🔥, 0💬
Popular Posts:
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
How AdventureWorksLT tables are related in SQL Server? There are 12 user tables defined in Adventure...
How To Set Up SQL*Plus Output Format in Oracle? If you want to practice SQL statements with SQL*Plus...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...