SQL Server 查看列，添加列，修改列，删除列代码,MSSQL代码库,德仔网

代码语言

代码分类

【MSSQL】 SQL Server 查看列，添加列，修改列，删除列

作者:Dezai.CN / 发布于2011/7/7/ 493

<div>
查看表：<span style="font-family: Consolas" face="Consolas"><span style="color: rgb(0,0,255)" color="#0000ff">exec</span> <span style="color: rgb(155,0,211)" color="#9b00d3">sp_help</span> 表名</span>
<ul>
    <li>
    查<span style="color: rgb(51,51,51)" color="#333333">看</span>列： <span style="font-family: Consolas" face="Consolas"><span style="color: rgb(0,0,255)" color="#0000ff">exec</span> <span style="color: rgb(155,0,211)" color="#9b00d3">sp_columns</span> 表名</span>
    </li>
    <li>
    <span style="font-family: Consolas" face="Consolas"><span style="font-family: 微软雅黑" face="微软雅黑">查看列</span>：</span><span style="color: rgb(0,0,255)" color="#0000ff"><span style="font-family: Consolas" face="Consolas">select <span style="color: rgb(51,51,51)" color="#333333">*</span> from <span style="color: rgb(155,0,211)" color="#9b00d3">information_schema.columns</span> where <span style="color: rgb(75,172,198)" color="#4bacc6">table_name </span>= <span style="color: rgb(255,0,0)" color="#ff0000">'表名' </span></span></span>
    </li>
    <li>
    <span style="color: rgb(51,51,51)" color="#333333">添加列：<span style="font-family: Consolas" face="Consolas"><span style="color: rgb(0,0,255)" color="#0000ff">alter table</span> 表名 <span style="color: rgb(0,0,255)" color="#0000ff">add</span> 列名 <span style="color: rgb(0,0,255)" color="#0000ff">varchar(55)</span></span></span>
    </li>
    <li>
    <span style="color: rgb(51,51,51)" color="#333333">删除列：<span style="font-family: Consolas" face="Consolas"><span style="color: rgb(0,0,255)" color="#0000ff">alter table</span> 表名 <span style="color: rgb(0,0,255)" color="#0000ff">drop column</span> 列名</span></span>
    </li>
    <li>
    <span style="color: rgb(51,51,51)" color="#333333">修改列名称：<span style="font-family: Consolas" face="Consolas"><span style="color: rgb(0,0,255)" color="#0000ff">exec</span> <span style="color: rgb(155,0,211)" color="#9b00d3">sp_rename</span> '表名.字段名' , '新名', '<span style="color: rgb(0,0,255)" color="#0000ff">column</span>' </span></span>
    </li>
    <li>
    <span style="color: rgb(51,51,51)" color="#333333">修改列类型：</span><span style="font-family: Consolas; color: rgb(0,0,255)" color="#0000ff" face="Consolas">alter table <span style="color: rgb(51,51,51)" color="#333333">表名</span> alter column <span style="color: rgb(51,51,51)" color="#333333">列名</span> varchar(22)</span>
    </li>
</ul>
</div>

试试其它关键字

同语言下

可能有用的

Dezai.CN贡献的其它代码(4037)