• W3CSchooL标准之路
  • 学习 SQL 教程
登录

学习 SQL 教程

  • SQL 教程
  • SQL 简介
  • SQL 语法
  • SQL Select
  • SQL Select Distinct
  • SQL Where
  • SQL And, Or, Not
  • SQL Order By
  • SQL Insert Into
  • SQL Null Values
  • SQL Update
  • SQL Delete
  • SQL Select Top
  • SQL Min 和 Max
  • SQL Count, Avg, Sum
  • SQL Like
  • SQL 通配符
  • SQL In
  • SQL Between
  • SQL 别名
  • SQL 联接
  • SQL Inner Join
  • SQL Left Join
  • SQL Right Join
  • SQL Full Join
  • SQL 自联接
  • SQL Union
  • SQL Group By
  • SQL Having
  • SQL Exists
  • SQL Any, All
  • SQL Select Into
  • SQL Insert Into Select
  • SQL Case
  • SQL Null 函数
  • SQL 存储过程
  • SQL 注释
  • SQL 运算符
  • SQL 数据库
    • SQL 创建数据库
    • SQL 删除数据库
    • SQL 数据库备份
    • SQL Create Table
    • SQL Drop Table
    • SQL Alter Table
    • SQL 约束
    • SQL Not Null
    • SQL Unique
    • SQL Primary Key
    • SQL Foreign Key
    • SQL Check
    • SQL Default
    • SQL Index
    • SQL 自动增量
    • SQL 日期
    • SQL 视图
    • SQL 注入
    • SQL 托管
    • SQL 数据类型
  • SQL 参考手册
    • SQL 关键字
      • ADD
      • ADD CONSTRAINT
      • ALTER
      • ALTER COLUMN
      • ALTER TABLE
      • ALL
      • AND
      • ANY
      • AS
      • ASC
      • BACKUP DATABASE
      • BETWEEN
      • CASE
      • CHECK
      • COLUMN
      • CONSTRAINT
      • CREATE
      • CREATE DATABASE
      • CREATE INDEX
      • CREATE OR REPLACE VIEW
      • CREATE TABLE
      • CREATE PROCEDURE
      • CREATE UNIQUE INDEX
      • CREATE VIEW
      • DATABASE
      • DEFAULT
      • DELETE
      • DESC
      • DISTINCT
      • DROP
      • DROP COLUMN
      • DROP CONSTRAINT
      • DROP DATABASE
      • DROP DEFAULT
      • DROP INDEX
      • DROP TABLE
      • DROP VIEW
      • EXEC
      • EXISTS
      • FOREIGN KEY
      • FROM
      • FULL OUTER JOIN
      • GROUP BY
      • HAVING
      • IN
      • INDEX
      • INNER JOIN
      • INSERT INTO
      • INSERT INTO SELECT
      • IS NULL
      • IS NOT NULL
      • JOIN
      • LEFT JOIN
      • LIKE
      • LIMIT
      • NOT
      • NOT NULL
      • OR
      • ORDER BY
      • OUTER JOIN
      • PRIMARY KEY
      • PROCEDURE
      • RIGHT JOIN
      • ROWNUM
      • SELECT
      • SELECT DISTINCT
      • SELECT INTO
      • SELECT TOP
      • SET
      • TABLE
      • TOP
      • TRUNCATE TABLE
      • UNION
      • UNION ALL
      • UNIQUE
      • UPDATE
      • VALUES
      • VIEW
      • WHERE
    • MySQL 函数
      • ASCII
      • CHAR_LENGTH
      • CHARACTER_LENGTH
      • CONCAT
      • CONCAT_WS
      • FIELD
      • FIND_IN_SET
      • FORMAT
      • INSERT
      • INSTR
      • LCASE
      • LEFT
      • LENGTH
      • LOCATE
      • LOWER
      • LPAD
      • LTRIM
      • MID
      • POSITION
      • REPEAT
      • REPLACE
      • REVERSE
      • RIGHT
      • RPAD
      • RTRIM
      • SPACE
      • STRCMP
      • SUBSTR
      • SUBSTRING
      • SUBSTRING_INDEX
      • TRIM
      • UCASE
      • UPPER
      • ABS
      • ACOS
      • ASIN
      • ATAN
      • ATAN2
      • AVG
      • CEIL
      • CEILING
      • COS
      • COT
      • COUNT
      • DEGREES
      • DIV
      • EXP
      • FLOOR
      • GREATEST
      • LEAST
      • LN
      • LOG
      • LOG10
      • LOG2
      • MAX
      • MIN
      • MOD
      • PI
      • POW
      • POWER
      • RADIANS
      • RAND
      • ROUND
      • SIGN
      • SIN
      • SQRT
      • SUM
      • TAN
      • TRUNCATE
      • ADDDATE
      • ADDTIME
      • CURDATE
      • CURRENT_DATE
      • CURRENT_TIME
      • CURRENT_TIMESTAMP
      • CURTIME
      • DATE
      • DATEDIFF
      • DATE_ADD
      • DATE_FORMAT
      • DATE_SUB
      • DAY
      • DAYNAME
      • DAYOFMONTH
      • DAYOFWEEK
      • DAYOFYEAR
      • EXTRACT
      • FROM_DAYS
      • HOUR
      • LAST_DAY
      • LOCALTIME
      • LOCALTIMESTAMP
      • MAKEDATE
      • MAKETIME
      • MICROSECOND
      • MINUTE
      • MONTH
      • MONTHNAME
      • NOW
      • PERIOD_ADD
      • PERIOD_DIFF
      • QUARTER
      • SECOND
      • SEC_TO_TIME
      • STR_TO_DATE
      • SUBDATE
      • SUBTIME
      • SYSDATE
      • TIME
      • TIME_FORMAT
      • TIME_TO_SEC
      • TIMEDIFF
      • TIMESTAMP
      • TO_DAYS
      • WEEK
      • WEEKDAY
      • WEEKOFYEAR
      • YEAR
      • YEARWEEK
      • BIN
      • BINARY
      • CASE
      • CAST
      • COALESCE
      • CONNECTION_ID
      • CONV
      • CONVERT
      • CURRENT_USER
      • DATABASE
      • IF
      • IFNULL
      • ISNULL
      • LAST_INSERT_ID
      • NULLIF
      • SESSION_USER
      • SYSTEM_USER
      • USER
      • VERSION
    • SQL Server 函数
      • ASCII
      • CHAR
      • CHARINDEX
      • CONCAT
      • Concat with +
      • CONCAT_WS
      • DATALENGTH
      • DIFFERENCE
      • FORMAT
      • LEFT
      • LEN
      • LOWER
      • LTRIM
      • NCHAR
      • PATINDEX
      • QUOTENAME
      • REPLACE
      • REPLICATE
      • REVERSE
      • RIGHT
      • RTRIM
      • SOUNDEX
      • SPACE
      • STR
      • STUFF
      • SUBSTRING
      • TRANSLATE
      • TRIM
      • UNICODE
      • UPPER
      • ABS
      • ACOS
      • ASIN
      • ATAN
      • ATN2
      • AVG
      • CEILING
      • COUNT
      • COS
      • COT
      • DEGREES
      • EXP
      • FLOOR
      • LOG
      • LOG10
      • MAX
      • MIN
      • PI
      • POWER
      • RADIANS
      • RAND
      • ROUND
      • SIGN
      • SIN
      • SQRT
      • SQUARE
      • SUM
      • TAN
      • CURRENT_TIMESTAMP
      • DATEADD
      • DATEDIFF
      • DATEFROMPARTS
      • DATENAME
      • DATEPART
      • DAY
      • GETDATE
      • GETUTCDATE
      • ISDATE
      • MONTH
      • SYSDATETIME
      • YEAR
      • CAST
      • COALESCE
      • CONVERT
      • CURRENT_USER
      • IIF
      • ISNULL
      • ISNUMERIC
      • NULLIF
      • SESSION_USER
      • SESSIONPROPERTY
      • SYSTEM_USER
      • USER_NAME
    • MS Access 函数
      • Asc
      • Chr
      • Concat with &
      • CurDir
      • Format
      • InStr
      • InstrRev
      • LCase
      • Left
      • Len
      • LTrim
      • Mid
      • Replace
      • Right
      • RTrim
      • Space
      • Split
      • Str
      • StrComp
      • StrConv
      • StrReverse
      • Trim
      • UCase
      • Abs
      • Atn
      • Avg
      • Cos
      • Count
      • Exp
      • Fix
      • Format
      • Int
      • Max
      • Min
      • Randomize
      • Rnd
      • Round
      • Sgn
      • Sqr
      • Sum
      • Val
      • Date
      • DateAdd
      • DateDiff
      • DatePart
      • DateSerial
      • DateValue
      • Day
      • Format
      • Hour
      • Minute
      • Month
      • MonthName
      • Now
      • Second
      • Time
      • TimeSerial
      • TimeValue
      • Weekday
      • WeekdayName
      • Year
      • CurrentUser
      • Environ
      • IsDate
      • IsNull
      • IsNumeric
    • SQL 快速参考手册
  • SQL 实例
    • SQL 实例
    • SQL 测验
    • SQL 练习

ALTER COLUMN

创建于 2024-12-02 / 31
字体： [默认] [大] [更大]

❮ SQL 关键字参考

ALTER COLUMN

ALTER COLUMN命令用于改变表中某列的数据类型。

下面的SQL将"BirthDate"表中"BirthDate"列的数据类型改为年份:

实例

ALTER TABLE Employees
ALTER COLUMN BirthDate year; 亲自试一试 »

❮ SQL 关键字参考


0 人点赞过
  • 上一篇：ALTER
  • 下一篇：ALTER TABLE
W3CSchooL标准之路
PESCMS官网 使用帮助 软件协议 Power By PESCMS DOC 闽ICP备2023009822号-1