{"id":7607,"date":"2019-01-11T20:50:00","date_gmt":"2019-01-11T20:50:00","guid":{"rendered":"https:\/\/dbtut.com\/?p=7607"},"modified":"2019-01-11T20:52:11","modified_gmt":"2019-01-11T20:52:11","slug":"alter-table-statement-in-sql-servertsql","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/01\/11\/alter-table-statement-in-sql-servertsql\/","title":{"rendered":"ALTER TABLE Statement in SQL Server(TSQL)"},"content":{"rendered":"<p>We can perform the following operations with ALTER TABLE Statement.<\/p>\n<ul>\n<li>Add a column to a table<\/li>\n<li>Delete a column from a table<\/li>\n<li>Change the data type of a column<\/li>\n<li>Increase or decrease the size of a column<\/li>\n<li>Switch Partition<\/li>\n<li>Enable or disable Constraints or triggers<\/li>\n<\/ul>\n<p>In this article I will describe the above items through an example. In order to use our examples, we create a table as below and add a few records.<\/p>\n<pre class=\"lang:default decode:true\">USE [TestDB]\nGO\nCREATE TABLE [dbo].[Person](\n[ID] [int] NOT NULL,\n[Name] [varchar](10) NOT NULL\n) ON [PRIMARY]\nGO\nINSERT INTO [dbo].[Person] VALUES (1,'Nurullah'),(2,'Faruk')<\/pre>\n<p><strong>Add a column to the table:<\/strong><\/p>\n<p>We are adding a column in the varchar (10) data type with the help of the following script. After adding the column, we see that when we read the table with SELECT, the values of the column that we added are returned as NULL for existing records.<\/p>\n<pre class=\"lang:default decode:true\">ALTER TABLE dbo.Person ADD Surname varchar(10) NULL\nSelect * FROM dbo.Person<\/pre>\n<p id=\"YjmaSOT\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-7609  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c38ff6fb7f7b.png\" alt=\"\" width=\"599\" height=\"254\" \/><\/p>\n<p><strong>Drop a column from the table:<\/strong><\/p>\n<p>We drop the column we added with the help of the following script.<\/p>\n<pre class=\"lang:default decode:true\">ALTER TABLE dbo.Person DROP COLUMN Surname\nSelect * FROM dbo.Person<\/pre>\n<p><strong>Change the column&#8217;s data type:<\/strong><\/p>\n<p>Changing the column&#8217;s data type is a bit more complicated. If we change the data type of the column, the values in the column must match the new data type.<\/p>\n<p>With the following script, we convert the data type of the Name column from varchar (10) to nvarchar (10).<\/p>\n<pre class=\"lang:default decode:true\">ALTER TABLE dbo.Person ALTER COLUMN [Name] nvarchar(10);<\/pre>\n<p>When there are text data in the column, if we try to change the data type to int, we will get the error as follows.<\/p>\n<pre class=\"lang:default decode:true\">ALTER TABLE dbo.Person ALTER COLUMN [Name] int;<\/pre>\n<p style=\"margin: 0in; font-family: Georgia; font-size: 12.0pt;\"><em>Msg 245, Level 16, State 1, Line 2<\/em><\/p>\n<p style=\"margin: 0in; font-family: Georgia; font-size: 12.0pt;\"><em>Conversion failed when converting the nvarchar value &#8216;Nurullah&#8217; to data type int.<\/em><\/p>\n<p style=\"margin: 0in; font-family: Georgia; font-size: 12.0pt;\"><em>The statement has been terminated.<\/em><\/p>\n<p id=\"XuwejCi\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-7611  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c38ffccc1042.png\" alt=\"\" width=\"609\" height=\"189\" \/><\/p>\n<p><strong>Increase or decrease the column&#8217;s size:<\/strong><\/p>\n<p><strong>Set column size as a larger value:<\/strong><\/p>\n<p>Let&#8217;s increase the size of the column without changing the data type. We can do this quickly without any interruption.(Even if the table is too large)<\/p>\n<pre class=\"lang:default decode:true \">ALTER TABLE dbo.Person ALTER COLUMN [Name] nvarchar(100);<\/pre>\n<p><strong>Set column size as a smaller value:<\/strong><\/p>\n<p>This process is a little more complicated. Because the column&#8217;s current data may not allow it. Let&#8217;s go back to our example. There are two records in the table &#8220;dbo.Personel&#8221; (Nurullah and Faruk). Let&#8217;s try to set the data type of this column as varchar (5).<\/p>\n<pre class=\"lang:default decode:true\">ALTER TABLE dbo.Person ALTER COLUMN [Name] varchar(5);\n\n<\/pre>\n<p>Since the largest data in the table is 8 characters, the smallest value we can set is varchar (8). If we try to set as a smaller value, we get the error as follows.<\/p>\n<p style=\"margin: 0in; font-family: Georgia; font-size: 12.0pt;\"><em>Msg 8152, Level 16, State 2, Line 1<\/em><\/p>\n<p style=\"margin: 0in; font-family: Georgia; font-size: 12.0pt;\"><em>String or binary data would be truncated.<\/em><\/p>\n<p style=\"margin: 0in; font-family: Georgia; font-size: 12.0pt;\"><em>The statement has been terminated.<\/em><\/p>\n<p id=\"FSEmPxS\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-7613  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c39003451742.png\" alt=\"\" width=\"555\" height=\"176\" \/><\/p>\n<p style=\"margin: 0in; font-family: Georgia; font-size: 12.0pt;\">You can use the following script to calculate the maximum data length of the column in the table.<\/p>\n<pre class=\"lang:default decode:true \">SELECT MAX(LEN([NAME])) AS MAXIMUM_NAME_LENGHT FROM dbo.Person;<\/pre>\n<p id=\"LLDetKa\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-7615  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c39005d331cb.png\" alt=\"\" width=\"548\" height=\"189\" \/><\/p>\n<p><strong>Switch Partition:<\/strong><\/p>\n<p>You can find details in the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/08\/19\/sliding-window-switch-partition-split-range-merge-range\/\" target=\"_blank\" rel=\"noopener\">Sliding Window-Switch Partition-Split Range-Merge Range<\/a>&#8220;.<\/p>\n<p><strong>To enable or disable Constraint or Triggers:<\/strong><\/p>\n<p>With ALTER Table we can add and delete constraint. You can find details in the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/07\/05\/how-to-create-check-constraint\/\" target=\"_blank\" rel=\"noopener\">How To Create CHECK CONSTRAINT<\/a>&#8220;. You may want to read the article &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/07\/02\/sql-server-trigger-types\/\" target=\"_blank\" rel=\"noopener\">SQL Server Trigger Types<\/a>&#8220;.<\/p>\n<p>With the following script, we disable the trigger named myTrigger in the table.<\/p>\n<pre class=\"lang:default decode:true\">ALTER TABLE dbo.Person DISABLE TRIGGER myTrigger;<\/pre>\n<p>With the following script, we enable the trigger named myTrigger in the table.<\/p>\n<pre class=\"lang:default decode:true\">ALTER TABLE dbo.Person ENABLE TRIGGER myTrigger;<\/pre>\n<p>With the following script, we disable the constraint named myConstraint in the table.<\/p>\n<pre class=\"lang:default decode:true\">ALTER TABLE dbo.Person NOCHECK CONSTRAINT myConstraint;<\/pre>\n<p>With the following script, we enable the constraint named myConstraint in the table.<\/p>\n<pre class=\"lang:default decode:true \">ALTER TABLE dbo.Person CHECK CONSTRAINT myConstraint;<\/pre>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_7607\" class=\"pvc_stats all  \" data-element-id=\"7607\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>We can perform the following operations with ALTER TABLE Statement. Add a column to a table Delete a column from a table Change the data type of a column Increase or decrease the size of a column Switch Partition Enable or disable Constraints or triggers In this article I will describe the above items through &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_7607\" class=\"pvc_stats all  \" data-element-id=\"7607\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3,1596],"tags":[1642,1649,1648,1644,1647,1646,1643,1645,1650,1651],"class_list":["post-7607","post","type-post","status-publish","format-standard","","category-mssql","category-tsql","tag-alter-table-add-column","tag-alter-table-disable-constraint","tag-alter-table-disable-trigger","tag-alter-table-drop-column","tag-alter-table-enable-constraint","tag-alter-table-enable-trigger","tag-alter-table-modify-column","tag-alter-table-switch-partition","tag-conversion-failed-when-converting-the-nvarchar-value-to-data-type-int","tag-string-or-binary-data-would-be-truncated"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":307,"today_views":1},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>ALTER TABLE Statement in SQL Server(TSQL) - Database Tutorials<\/title>\n<meta name=\"description\" content=\"ALTER TABLE Statement in SQL Server(TSQL)\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/01\/11\/alter-table-statement-in-sql-servertsql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ALTER TABLE Statement in SQL Server(TSQL) - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"ALTER TABLE Statement in SQL Server(TSQL)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/01\/11\/alter-table-statement-in-sql-servertsql\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-01-11T20:50:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-01-11T20:52:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c38ff6fb7f7b.png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/11\/alter-table-statement-in-sql-servertsql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/11\/alter-table-statement-in-sql-servertsql\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"ALTER TABLE Statement in SQL Server(TSQL)\",\"datePublished\":\"2019-01-11T20:50:00+00:00\",\"dateModified\":\"2019-01-11T20:52:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/11\/alter-table-statement-in-sql-servertsql\/\"},\"wordCount\":517,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/11\/alter-table-statement-in-sql-servertsql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c38ff6fb7f7b.png\",\"keywords\":[\"alter table add column\",\"alter table disable constraint\",\"alter table disable trigger\",\"alter table drop column\",\"alter table enable constraint\",\"alter table enable trigger\",\"alter table modify column\",\"alter table switch partition\",\"Conversion failed when converting the nvarchar value '' to data type int.\",\"String or binary data would be truncated\"],\"articleSection\":[\"MSSQL\",\"TSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/01\/11\/alter-table-statement-in-sql-servertsql\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/11\/alter-table-statement-in-sql-servertsql\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/11\/alter-table-statement-in-sql-servertsql\/\",\"name\":\"ALTER TABLE Statement in SQL Server(TSQL) - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/11\/alter-table-statement-in-sql-servertsql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/11\/alter-table-statement-in-sql-servertsql\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c38ff6fb7f7b.png\",\"datePublished\":\"2019-01-11T20:50:00+00:00\",\"dateModified\":\"2019-01-11T20:52:11+00:00\",\"description\":\"ALTER TABLE Statement in SQL Server(TSQL)\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/11\/alter-table-statement-in-sql-servertsql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/01\/11\/alter-table-statement-in-sql-servertsql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/11\/alter-table-statement-in-sql-servertsql\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c38ff6fb7f7b.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c38ff6fb7f7b.png\",\"width\":711,\"height\":301},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/01\/11\/alter-table-statement-in-sql-servertsql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ALTER TABLE Statement in SQL Server(TSQL)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"ALTER TABLE Statement in SQL Server(TSQL) - Database Tutorials","description":"ALTER TABLE Statement in SQL Server(TSQL)","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2019\/01\/11\/alter-table-statement-in-sql-servertsql\/","og_locale":"en_US","og_type":"article","og_title":"ALTER TABLE Statement in SQL Server(TSQL) - Database Tutorials","og_description":"ALTER TABLE Statement in SQL Server(TSQL)","og_url":"https:\/\/dbtut.com\/index.php\/2019\/01\/11\/alter-table-statement-in-sql-servertsql\/","og_site_name":"Database Tutorials","article_published_time":"2019-01-11T20:50:00+00:00","article_modified_time":"2019-01-11T20:52:11+00:00","og_image":[{"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c38ff6fb7f7b.png","type":"","width":"","height":""}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/11\/alter-table-statement-in-sql-servertsql\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/11\/alter-table-statement-in-sql-servertsql\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"ALTER TABLE Statement in SQL Server(TSQL)","datePublished":"2019-01-11T20:50:00+00:00","dateModified":"2019-01-11T20:52:11+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/11\/alter-table-statement-in-sql-servertsql\/"},"wordCount":517,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/11\/alter-table-statement-in-sql-servertsql\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c38ff6fb7f7b.png","keywords":["alter table add column","alter table disable constraint","alter table disable trigger","alter table drop column","alter table enable constraint","alter table enable trigger","alter table modify column","alter table switch partition","Conversion failed when converting the nvarchar value '' to data type int.","String or binary data would be truncated"],"articleSection":["MSSQL","TSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/01\/11\/alter-table-statement-in-sql-servertsql\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/11\/alter-table-statement-in-sql-servertsql\/","url":"https:\/\/dbtut.com\/index.php\/2019\/01\/11\/alter-table-statement-in-sql-servertsql\/","name":"ALTER TABLE Statement in SQL Server(TSQL) - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/11\/alter-table-statement-in-sql-servertsql\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/11\/alter-table-statement-in-sql-servertsql\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c38ff6fb7f7b.png","datePublished":"2019-01-11T20:50:00+00:00","dateModified":"2019-01-11T20:52:11+00:00","description":"ALTER TABLE Statement in SQL Server(TSQL)","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/11\/alter-table-statement-in-sql-servertsql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/01\/11\/alter-table-statement-in-sql-servertsql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/11\/alter-table-statement-in-sql-servertsql\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c38ff6fb7f7b.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/01\/img_5c38ff6fb7f7b.png","width":711,"height":301},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/01\/11\/alter-table-statement-in-sql-servertsql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"ALTER TABLE Statement in SQL Server(TSQL)"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/7607","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=7607"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/7607\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=7607"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=7607"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=7607"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}