Differences

This shows you the differences between two versions of the page.

oracle:default [June 10, 2012 12:01 pm]
sqlines created
oracle:default [June 10, 2012 12:02 pm] (current)
sqlines
Line 9: Line 9:
==== ALTER TABLE - Add DEFAULT to Existing Table ==== ==== ALTER TABLE - Add DEFAULT to Existing Table ====
-In Oracle, you can use ALTER TABLE statement to add the default value for a column in an existing table:+In Oracle, you can use ALTER TABLE statement with MODIFY clause to add the default value for a column in an existing table:
**Oracle**: **Oracle**:
Line 28: Line 28:
</code> </code>
-In SQL Server, you can also use ALTER TABLE statement, but with ADD DEFAULT:+In SQL Server, you can also use ALTER TABLE statement, but with ADD DEFAULT clause:
**SQL Server**: **SQL Server**: