<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[ZackYang_one的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/ZackYang_one</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; ZackYang_one]]></copyright><item><title><![CDATA[sql主键删除/sql主键修改]]></title><link>https://blog.youkuaiyun.com/ZackYang_one/article/details/108756256</link><guid>https://blog.youkuaiyun.com/ZackYang_one/article/details/108756256</guid><author>ZackYang_one</author><pubDate>Wed, 23 Sep 2020 16:42:31 +0800</pubDate><description><![CDATA[sql主键删除/sql主键修改
1.删除主键
--查询主键键名
SELECT name FROM sysobjects  WHERE xtype='pk' AND object_name(parent_obj) ='表名'
--执行删除
ALTER TABLE 表名 DROP  上一句执行结果放在这里

2.创建主键
ALTER TABLE 表名 ADD PRIMARY KEY (Id,...,...)

3.修改主键
--先执行1，在执行2


...]]></description><category></category></item></channel></rss>