{{theTime}}

Search This Blog

Total Pageviews

How to Add or Drop a column in sql?

Add a column:

ALTER TABLE <TABLE_NAME> ADD COLUMN <COLUMN-NAME>

Drop a Column:

ALTER TABLE <TABLE_NAME> DROP COLUMN <COLUMN-NAME>

No comments:

Windows 8.3 file naming setting is disabled for the product

To enable Windows 8.3 file naming setting use fsutil command Example:  c:\> fsutil 8dot3name set C: 0