–1.\u7ed9\u8868\u4e2d\u5b57\u6bb5\u6dfb\u52a0\u63cf\u8ff0\u4fe1\u606f
Create table T2 (id int , name char (20))
GO
EXEC sp_addextendedproperty ‘MS_Description’, ‘Employee ID’, ‘user’, dbo, ‘table’, T2, ‘column’, id<\/p>\n
EXEC sp_updateextendedproperty ‘MS_Description’, ‘this is a test’, ‘user’, dbo, ‘table’, T2, ‘column’, id<\/p>\n
–2.\u4fee\u6539\u6570\u636e\u5e93\u540d\u79f0
EXEC sp_renamedb ‘old_db_name’, ‘new_db_name’<\/p>\n
–3.\u4fee\u6539\u6570\u636e\u8868\u540d\u79f0\u548c\u5b57\u6bb5\u540d\u79f0
EXEC sp_rename ‘old_table_name’, ‘new_table_name’–\u4fee\u6539\u6570\u636e\u8868\u540d\u79f0
EXEC sp_rename ‘table_name.[old_column_name]’, ‘new_column_name’, ‘COLUMN’–\u4fee\u6539\u5b57\u6bb5\u540d\u79f0<\/p>\n
–4.\u7ed9\u5b9a\u5b58\u50a8\u8fc7\u7a0b\u540d\uff0c\u83b7\u53d6\u5b58\u50a8\u8fc7\u7a0b\u5185\u5bb9
exec sp_helptext sp_name<\/p>\n","protected":false},"excerpt":{"rendered":"
–1.\u7ed9\u8868\u4e2d\u5b57\u6bb5\u6dfb\u52a0\u63cf\u8ff0\u4fe1\u606fCreate &n...<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":["post-90","post","type-post","status-publish","format-standard","hentry","category-DB"],"_links":{"self":[{"href":"https:\/\/www.poloo.org\/index.php?rest_route=\/wp\/v2\/posts\/90","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.poloo.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.poloo.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.poloo.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.poloo.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=90"}],"version-history":[{"count":0,"href":"https:\/\/www.poloo.org\/index.php?rest_route=\/wp\/v2\/posts\/90\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.poloo.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=90"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.poloo.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=90"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.poloo.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=90"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}