Articles about sql-server.
Trying to rename a column today in an MSSQL database. I expected the standard ALTER TABLE x CHANGE oldColumn newColumn <type> to work, but apparently that's a MySQL-only thing? Instead I did a quick Google search and came up with this nugget:
Where chr(10) is the myDateField column type to expect and 103 is the date format to use. The 100-plus date format codes will display a 4-digit year, whereas the 0-100 codes will display a 2-digit year. (Not recommended, if you ask me!)
First, see this quote from Modify Unique Constraints:
For all those MySQL devs who miss the simplicity of SHOW CREATE TABLE myTable or SHOW COLUMNS FROM myTable, here's the snippet you are looking for.