{"id":25158,"date":"2018-08-17T07:17:38","date_gmt":"2018-08-17T07:17:38","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=25158"},"modified":"2018-09-13T11:09:10","modified_gmt":"2018-09-13T05:39:10","slug":"sql-create-table","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/sql-create-table\/","title":{"rendered":"SQL Create Table | SQL Alter and Drop Table"},"content":{"rendered":"<div class='__iawmlf-post-loop-links' style='display:none;' data-iawmlf-post-links='[{&quot;id&quot;:1817,&quot;href&quot;:&quot;http:\\\/\\\/www.sqlcourse.com&quot;,&quot;archived_href&quot;:&quot;http:\\\/\\\/web-wp.archive.org\\\/web\\\/20250909003917\\\/https:\\\/\\\/www.sqlcourse.com\\\/&quot;,&quot;redirect_href&quot;:&quot;&quot;,&quot;checks&quot;:[{&quot;date&quot;:&quot;2025-12-10 03:06:24&quot;,&quot;http_code&quot;:206},{&quot;date&quot;:&quot;2025-12-17 05:46:08&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2025-12-27 09:24:23&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-02 11:57:36&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-09 01:29:28&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-12 06:52:56&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-19 01:58:18&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-01-25 04:38:21&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-10 16:59:56&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-02-23 02:51:32&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-03-11 09:28:00&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-04-08 02:16:27&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-05-19 14:04:40&quot;,&quot;http_code&quot;:200},{&quot;date&quot;:&quot;2026-05-23 05:32:08&quot;,&quot;http_code&quot;:200}],&quot;broken&quot;:false,&quot;last_checked&quot;:{&quot;date&quot;:&quot;2026-05-23 05:32:08&quot;,&quot;http_code&quot;:200},&quot;process&quot;:&quot;done&quot;}]'><\/div>\n<h2>1. SQL Create, Alter, and Drop Table<\/h2>\n<p><span style=\"font-weight: 400\">In this <strong><a href=\"https:\/\/data-flair.training\/blogs\/sql-tutorial\/\">SQL tutorial<\/a><\/strong>, we are going to learn about the SQL Create, Alter, and Drop Table Statements. Moreover, we will see commands in SQL Create, Alter, and Drop Table. Also, we discuss the SQL Create Table, SQL Drop Table, SQL Alter Table with example and syntax. Along with this, SQL Create, Alter, and Drop Table Tutorial contain add, drop and modify a column in SQL.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">Now, for understanding SQL Create, Alter and Drop Table in detail, let&#8217;s start with the SQL Create Table.<\/span><\/p>\n<div id=\"attachment_25186\" style=\"width: 1210px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Create-drop-and-alter-table-in-SQL-01-2.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-25186\" class=\"wp-image-25186 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Create-drop-and-alter-table-in-SQL-01-2.jpg\" alt=\"SQL Create Table | SQL Alter and Drop Table\" width=\"1200\" height=\"628\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Create-drop-and-alter-table-in-SQL-01-2.jpg 1200w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Create-drop-and-alter-table-in-SQL-01-2-150x79.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Create-drop-and-alter-table-in-SQL-01-2-300x157.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Create-drop-and-alter-table-in-SQL-01-2-768x402.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Create-drop-and-alter-table-in-SQL-01-2-1024x536.jpg 1024w\" sizes=\"auto, (max-width: 1200px) 100vw, 1200px\" \/><\/a><p id=\"caption-attachment-25186\" class=\"wp-caption-text\">SQL Create Table | SQL Alter and Drop Table<\/p><\/div>\n<h2>2. SQL CREATE TABLE<\/h2>\n<p>This table is used to create a table in SQL.<br \/>\n<strong>The Syntax of SQL Create Table<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\">CREATE TABLE table_name(\r\n  column1 datatype,\r\n  column2 datatype,\r\n  column3 datatype,\r\n  .....\r\n  columnN datatype,\r\n  PRIMARY KEY( one or more columns )\r\n);<\/pre>\n<p>For this situation, you need to create another table. The one of a kind name or identifier for the table takes after the CREATE TABLE command.<br \/>\n<strong><a href=\"https:\/\/data-flair.training\/blogs\/sql-rdbms\/\">Do you know about SQL RDBMS Concept<\/a><\/strong><br \/>\nA duplicate of a current table can be created utilizing a blend of the CREATE TABLE explanation and the SELECT proclamation. You can check the total points of interest at Create Table using another Table.<br \/>\n<strong>a. SQL Create Table Example<\/strong><br \/>\nThe accompanying code square is an illustration, which creates a CUSTOMERS table with an ID as an essential key and NOT NULL are the requirements demonstrating that these fields can&#8217;t be NULL while making records in this table \u2212<\/p>\n<pre class=\"EnlighterJSRAW\">SQL&gt; CREATE TABLE CUSTOMERS(\r\n  ID  INT            NOT NULL,\r\n  NAME VARCHAR (20)     NOT NULL,\r\n  AGE  INT            NOT NULL,\r\n  ADDRESS  CHAR (25) ,\r\n  SALARY   DECIMAL (18, 2),\r\n  PRIMARY KEY (ID)\r\n);<\/pre>\n<div id=\"attachment_25177\" style=\"width: 466px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/1-8-1.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-25177\" class=\"wp-image-25177 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/1-8-1.png\" alt=\"SQL Create Table\" width=\"456\" height=\"193\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/1-8-1.png 456w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/1-8-1-150x63.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/1-8-1-300x127.png 300w\" sizes=\"auto, (max-width: 456px) 100vw, 456px\" \/><\/a><p id=\"caption-attachment-25177\" class=\"wp-caption-text\">SQL Create Table Statement<\/p><\/div>\n<h2>3. SQL ALTER Table<\/h2>\n<p><span style=\"font-weight: 400\">An SQL ALTER table statement is used in SQL to delete, add or even modify the columns of an existing table. It is also used to introduce constraints in the table.<\/span><\/p>\n<div id=\"attachment_25176\" style=\"width: 1090px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/ALTER-Table-01.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-25176\" class=\"wp-image-25176 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/ALTER-Table-01.jpg\" alt=\"SQL Create Table\" width=\"1080\" height=\"1080\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/ALTER-Table-01.jpg 1080w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/ALTER-Table-01-150x150.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/ALTER-Table-01-300x300.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/ALTER-Table-01-768x768.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/ALTER-Table-01-1024x1024.jpg 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/ALTER-Table-01-100x100.jpg 100w\" sizes=\"auto, (max-width: 1080px) 100vw, 1080px\" \/><\/a><p id=\"caption-attachment-25176\" class=\"wp-caption-text\">SQL Alter Table Statement<\/p><\/div>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/alter-command-in-sql-truncate\/\">Have a look at SQL Alter Commands<\/a><\/strong><\/p>\n<h3><span style=\"font-weight: 400\">a. SQL ADD Column<\/span><\/h3>\n<p><span style=\"font-weight: 400\">This command is used to add a column in a table.<\/span><br \/>\n<span style=\"font-weight: 400\">The syntax for SQL Add Column in SQL ALTER table &#8211;<\/span><\/p>\n<pre class=\"EnlighterJSRAW\">ALTER TABLE table_name\r\nADD column_name datatype;<\/pre>\n<h3><span style=\"font-weight: 400\">b. SQL DROP Column<\/span><\/h3>\n<p><span style=\"font-weight: 400\">This command is used to delete a column in a table.<\/span><br \/>\n<span style=\"font-weight: 400\">The syntax for SQL Drop Column in SQL ALTER Table &#8211;<\/span><\/p>\n<pre class=\"EnlighterJSRAW\">ALTER TABLE table_name\r\nDROP COLUMN column_name;<\/pre>\n<h3><span style=\"font-weight: 400\">c. SQL ALTER\/MODIFY Column<\/span><\/h3>\n<p><span style=\"font-weight: 400\">We use this command to change the data type of a column in a table.<\/span><br \/>\n<span style=\"font-weight: 400\">The syntax of Alter Table Modify Column SQL Server \u2013<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><strong>SQL Server \/ MS Access<\/strong><\/li>\n<\/ul>\n<pre class=\"EnlighterJSRAW\">ALTER TABLE table_name\r\nALTER COLUMN column_name datatype;<\/pre>\n<ul>\n<li style=\"font-weight: 400\"><strong>My SQL \/ Oracle (prior version 10G)<\/strong><\/li>\n<\/ul>\n<p><strong><a href=\"https:\/\/data-flair.training\/blogs\/null-values-in-sql-union-clause\/\">Have a look at SQL Null Values<\/a><\/strong><\/p>\n<pre class=\"EnlighterJSRAW\">ALTER TABLE table_name\r\nMODIFY COLUMN column_name datatype;<\/pre>\n<ul>\n<li style=\"font-weight: 400\"><strong>Oracle 10G and later<\/strong><\/li>\n<\/ul>\n<pre class=\"EnlighterJSRAW\">ALTER TABLE table_name\r\nMODIFY column_name datatype;<\/pre>\n<h3><span style=\"font-weight: 400\">d. SQL ALTER TABLE Example<\/span><\/h3>\n<p><span style=\"font-weight: 400\">Look at the &#8220;Persons&#8221; table:<\/span><\/p>\n<table>\n<tbody>\n<tr>\n<td><strong>ID<\/strong><\/td>\n<td><strong>LastName<\/strong><\/td>\n<td><strong>FirstName<\/strong><\/td>\n<td><strong>Address<\/strong><\/td>\n<td><strong>City<\/strong><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">1<\/span><\/td>\n<td><span style=\"font-weight: 400\">Hansen<\/span><\/td>\n<td><span style=\"font-weight: 400\">Ola<\/span><\/td>\n<td><span style=\"font-weight: 400\">Timoteivn 10<\/span><\/td>\n<td><span style=\"font-weight: 400\">Sandnes<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">2<\/span><\/td>\n<td><span style=\"font-weight: 400\">Svendson<\/span><\/td>\n<td><span style=\"font-weight: 400\">Tove<\/span><\/td>\n<td><span style=\"font-weight: 400\">Borgvn 23<\/span><\/td>\n<td><span style=\"font-weight: 400\">Sandnes<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">3<\/span><\/td>\n<td><span style=\"font-weight: 400\">Pettersen<\/span><\/td>\n<td><span style=\"font-weight: 400\">Kari<\/span><\/td>\n<td><span style=\"font-weight: 400\">Storgt 20<\/span><\/td>\n<td><span style=\"font-weight: 400\">Stavanger<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>When we want to add an extra column \u201cdate of birth\u201d, we use the following command.<\/p>\n<pre class=\"EnlighterJSRAW\">ALTER TABLE Persons\r\nADD DateOfBirth date;<\/pre>\n<p>The &#8220;Persons&#8221; table will now look like this:<br \/>\n<strong><a href=\"https:\/\/data-flair.training\/blogs\/sql-wildcard\/\">Let&#8217;s discuss SQL Wildcard characters<\/a><\/strong><\/p>\n<table>\n<tbody>\n<tr>\n<td><strong>ID<\/strong><\/td>\n<td><strong>LastName<\/strong><\/td>\n<td><strong>FirstName<\/strong><\/td>\n<td><strong>Address<\/strong><\/td>\n<td><strong>City<\/strong><\/td>\n<td><strong>DateOfBirth<\/strong><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">1<\/span><\/td>\n<td><span style=\"font-weight: 400\">Hansen<\/span><\/td>\n<td><span style=\"font-weight: 400\">Ola<\/span><\/td>\n<td><span style=\"font-weight: 400\">Timoteivn 10<\/span><\/td>\n<td><span style=\"font-weight: 400\">Sandnes<\/span><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">2<\/span><\/td>\n<td><span style=\"font-weight: 400\">Svendson<\/span><\/td>\n<td><span style=\"font-weight: 400\">Tove<\/span><\/td>\n<td><span style=\"font-weight: 400\">Borgvn 23<\/span><\/td>\n<td><span style=\"font-weight: 400\">Sandnes<\/span><\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">3<\/span><\/td>\n<td><span style=\"font-weight: 400\">Pettersen<\/span><\/td>\n<td><span style=\"font-weight: 400\">Kari<\/span><\/td>\n<td><span style=\"font-weight: 400\">Storgt 20<\/span><\/td>\n<td><span style=\"font-weight: 400\">Stavanger<\/span><\/td>\n<td><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<ul>\n<li>Now if we want to change the data type of the column named &#8220;DateOfBirth&#8221; in the &#8220;Persons&#8221; table.<\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\">The Syntax for SQL ALTER Table \u2013<\/span><\/p>\n<pre class=\"EnlighterJSRAW\">ALTER TABLE Persons\r\nALTER COLUMN DateOfBirth year;<\/pre>\n<p><strong>DROP COLUMN Example<\/strong><br \/>\n<span style=\"font-weight: 400\">To delete the column named &#8220;DateOfBirth&#8221; in the &#8220;Persons&#8221; table.<\/span><br \/>\n<span style=\"font-weight: 400\">The syntax of Drop Column &#8211;<\/span><\/p>\n<pre class=\"EnlighterJSRAW\">ALTER TABLE Persons\r\nDROP COLUMN DateOfBirth;<\/pre>\n<h2>4. SQL DROP TABLE<\/h2>\n<p><span style=\"font-weight: 400\">The DROP TABLE statement is used to drop an existing table in a database.<\/span><br \/>\n<strong>The Syntax SQL DROP Table\u2013<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\">DROP TABLE table_name;<\/pre>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/sql-server-transaction\/\"><strong>You must read SQL Server Transactions<\/strong><\/a><br \/>\n<strong>a. SQL DROP Table Example<\/strong><\/p>\n<pre class=\"EnlighterJSRAW\">DROP TABLE CUSTOMERS;<\/pre>\n<p>So, this was all in SQL Create, Alter, and Drop table. Hope you like our explanation.<\/p>\n<h2><span style=\"font-weight: 400\">5. Conclusion: SQL Create, Alter, and Drop Table<\/span><\/h2>\n<p><span style=\"font-weight: 400\">Hence, in this SQL Create Tutorial, we learned about the Create, drop and alter command in SQL. Also, we discussed the example of SQL Create Table, SQL Alter table, and SQL Drop Table. If you like the article, then let us know through the comment. You can ask your query also.<\/span><br \/>\n<strong>See also &#8211;<\/strong><br \/>\n<strong><a href=\"https:\/\/data-flair.training\/blogs\/sql-constraint\/\">SQL Constraint<\/a><\/strong><br \/>\n<a href=\"http:\/\/www.sqlcourse.com\/\"><strong>For reference<\/strong><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>1. SQL Create, Alter, and Drop Table In this SQL tutorial, we are going to learn about the SQL Create, Alter, and Drop Table Statements. Moreover, we will see commands in SQL Create, Alter,&#46;&#46;&#46;<\/p>\n","protected":false},"author":6,"featured_media":25186,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[66],"tags":[428,2442,13398,13407,13429,13433,13449,13454],"class_list":["post-25158","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql","tag-alter-column-sql","tag-change-column-name-in-sql","tag-sql-add-column","tag-sql-alter-table-example","tag-sql-create-alter-and-drop-table","tag-sql-create-table-example","tag-sql-drop-and-create-table","tag-sql-drop-table-example"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Create Table | SQL Alter and Drop Table - DataFlair<\/title>\n<meta name=\"description\" content=\"SQL Create, Alter, and Drop table,SQL Create Table,SQL drop table,sql alter table,sql create table example,sql add column,sql drop column,alter column sql\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/sql-create-table\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Create Table | SQL Alter and Drop Table - DataFlair\" \/>\n<meta property=\"og:description\" content=\"SQL Create, Alter, and Drop table,SQL Create Table,SQL drop table,sql alter table,sql create table example,sql add column,sql drop column,alter column sql\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/sql-create-table\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-08-17T07:17:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-09-13T05:39:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Create-drop-and-alter-table-in-SQL-01-2.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Create Table | SQL Alter and Drop Table - DataFlair","description":"SQL Create, Alter, and Drop table,SQL Create Table,SQL drop table,sql alter table,sql create table example,sql add column,sql drop column,alter column sql","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:\/\/data-flair.training\/blogs\/sql-create-table\/","og_locale":"en_US","og_type":"article","og_title":"SQL Create Table | SQL Alter and Drop Table - DataFlair","og_description":"SQL Create, Alter, and Drop table,SQL Create Table,SQL drop table,sql alter table,sql create table example,sql add column,sql drop column,alter column sql","og_url":"https:\/\/data-flair.training\/blogs\/sql-create-table\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-08-17T07:17:38+00:00","article_modified_time":"2018-09-13T05:39:10+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Create-drop-and-alter-table-in-SQL-01-2.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/sql-create-table\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/sql-create-table\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"SQL Create Table | SQL Alter and Drop Table","datePublished":"2018-08-17T07:17:38+00:00","dateModified":"2018-09-13T05:39:10+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/sql-create-table\/"},"wordCount":642,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/sql-create-table\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Create-drop-and-alter-table-in-SQL-01-2.jpg","keywords":["alter column sql","Change column name in SQL","sql add column","sql alter table example","SQL create Alter and Drop Table","sql create table example","SQL drop and Create table","sql drop table example"],"articleSection":["SQL Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/sql-create-table\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/sql-create-table\/","url":"https:\/\/data-flair.training\/blogs\/sql-create-table\/","name":"SQL Create Table | SQL Alter and Drop Table - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/sql-create-table\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/sql-create-table\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Create-drop-and-alter-table-in-SQL-01-2.jpg","datePublished":"2018-08-17T07:17:38+00:00","dateModified":"2018-09-13T05:39:10+00:00","description":"SQL Create, Alter, and Drop table,SQL Create Table,SQL drop table,sql alter table,sql create table example,sql add column,sql drop column,alter column sql","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/sql-create-table\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/sql-create-table\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/sql-create-table\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Create-drop-and-alter-table-in-SQL-01-2.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/Create-drop-and-alter-table-in-SQL-01-2.jpg","width":1200,"height":628,"caption":"SQL Create Table | SQL Alter and Drop Table"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/sql-create-table\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"Searching for Groups of Scala Regex","item":"https:\/\/data-flair.training\/blogs\/tag\/searching-for-groups-of-scala-regex\/"},{"@type":"ListItem","position":3,"name":"SQL Create Table | SQL Alter and Drop Table"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"The DataFlair Team provides industry-driven content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our expert educators focus on delivering value-packed, easy-to-follow resources for tech enthusiasts and professionals.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam2\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/25158","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=25158"}],"version-history":[{"count":3,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/25158\/revisions"}],"predecessor-version":[{"id":30671,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/25158\/revisions\/30671"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/25186"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=25158"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=25158"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=25158"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}