{"id":8992,"date":"2023-05-26T06:40:00","date_gmt":"2023-05-26T04:40:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=8992"},"modified":"2023-07-29T15:13:25","modified_gmt":"2023-07-29T13:13:25","slug":"create-table-sql-server","status":"publish","type":"post","link":"https:\/\/expert-only.com\/en\/t-sql\/create-table-sql-server\/","title":{"rendered":"CREATE TABLE with SQL Server"},"content":{"rendered":"\n<h4 class=\"wp-block-heading has-text-align-left\" id=\"h-add-new-sample-sql-server-tables-using-the-create-table-statement-and-ssms\"><strong><em>Add new sample SQL Server tables using the create table statement and SSMS.<\/em><\/strong><\/h4>\n\n\n\n<p>Here is an example of a SQL Server Create Table script to create a customer or sales table. This T-SQL code is a Data Definition Language (DDL) or Data Definition Language (LDD) script. These tables are used as examples in many of the Transact-SQL articles on the Expert-Only site. These simple scripts first test if the table exists, if it does then it is deleted. Next, create the SQL Server Sales table. It has two columns, one for the months and one for the monthly sales amounts.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-1-create-table-with-sql-server-using-a-script\">1. CREATE TABLE with SQL Server using a script<\/h2>\n\n\n\n<p>Simply COPY \/ PASTE the script into SQL Server Management Studio (SSMS) for example. This table contains two columns:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>A MONTH column of type NVARCHAR(20)<\/li>\n\n\n\n<li>An AMOUNT column of type NUMERIC(5)<\/li>\n<\/ul>\n\n\n\n<p>To begin with, test if the table exists in our database with the exists() function. If it does, then the table is deleted with the T-SQL drop table command. Next, create the SALES table, which simply contains two columns:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">-- Test if the table already exists\n-- If it doaes then delete the table\nIF EXISTS(\n\tSELECT 1 FROM sys.objects\n\tWHERE object_id = object_id(N'[dbo].[SALES]')\n\t\tAND type in (N'U')\n)\nDROP TABLE [dbo].[Sales]\nGO\n\n-- Create the example table to store SALES\nCREATE TABLE [dbo].[Sales] (\n\t[MonthName] nvarchar(20),\n\t[Amount] numeric(8)\n)\nGO<\/pre>\n\n\n\n<p>The screenshot below illustrates the execution of the T-SQL in SSMS.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"697\" height=\"576\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/07\/create-table-sql-server-script-1.jpg\" alt=\"SQL Server CREATE TABLE script\" class=\"wp-image-9002\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/07\/create-table-sql-server-script-1.jpg 697w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/07\/create-table-sql-server-script-1-300x248.jpg 300w\" sizes=\"auto, (max-width: 697px) 100vw, 697px\" \/><figcaption class=\"wp-element-caption\"><strong>SQL Server<\/strong> <strong>CREATE TABLE script<\/strong><\/figcaption><\/figure><\/div>\n\n\n<p>After the table creation, insert a few rows in the table to handle data for the first three months of the calendar year, i.e., January, February and March, in all letters:<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">-- Insert sales data for our example\nINSERT INTO dbo.Sales (MonthName, Amount) VALUES ( N'January', 1000);\nINSERT INTO dbo.Sales (MonthName, Amount) VALUES ( N'February', 2000);\nINSERT INTO dbo.Sales (MonthName, Amount) VALUES ( N'March', 3000);\nGO\n\n-- Select results to check table contents\nSELECT \t*\nFROM \tdbo.Sales;\n<\/pre>\n\n\n\n<p>This image shows the result with the content of the sales tables, it contains 3 lines.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"858\" height=\"438\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/07\/sql-server-insert-into-table-script-1.jpg\" alt=\"Insert into the table and SELECT the SQL Server data in T-SQL\" class=\"wp-image-9014\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/07\/sql-server-insert-into-table-script-1.jpg 858w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/07\/sql-server-insert-into-table-script-1-300x153.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/07\/sql-server-insert-into-table-script-1-768x392.jpg 768w\" sizes=\"auto, (max-width: 858px) 100vw, 858px\" \/><figcaption class=\"wp-element-caption\">Insert into the table and SELECT the SQL Server data in T-SQL<\/figcaption><\/figure><\/div>\n\n\n<p>This article describes an example in Transact-sql to create a table that contains monthly sales data. The other SQL scripts on the blog use this example, which is deliberately basic.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-2-create-table-with-different-numeric-data-types\">2. Create Table with different numeric data types<\/h2>\n\n\n\n<p>This example of creating a Sales table uses different data types. The columns are for example of binary, numeric, integer or string types. One possible solution is to use a T-SQL CREATE TABLE command. For example, here is a code snippet that can be easily adapted to different needs to create a new table.<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">CREATE TABLE [dbo].[SALES] \n(\n\t[YearID] INT, \n\t[MonthName] NVARCHAR(50), -- alphanumeric\n\t[MonthCurrent] BIT, -- Boolean, 0 or 1 , false \/ true\n\t[NumberMonth] TINYINT, -- very small integer, from 0 to 255\n\t[EmployeeNumber] SMALLINT, -- small integer, minimum -2^15, maximum 2^15\n\t[NumberOfClients] INTEGER, -- integer, minimum -2^31, maximum 2^31\n\t[NumberOfSales] BIGINT, -- big integer, minimum: -2^63, maximum 2^63\n\t[Amount_ET] NUMERIC(15,5), -- numeric, 15 digits, with 5 after the comma \n\t[Amount_IT] DECIMAL(15,5) -- decimal, 15 digits, with 5 after the comma\n);\nGO\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-3-ms-sql-statement-to-add-a-customers-table-and-insert-data\">3. MS SQL statement to add a customers table and insert data<\/h2>\n\n\n\n<p>This third example concerns the CLIENTS table which is used in many tutorials. Then the SQL Server table called dbo.CUSTOMERS is created. In the same way, you just have to COPY \/ PASTE the <a href=\"https:\/\/dictionary.cambridge.org\/dictionary\/english\/script\" target=\"_blank\" rel=\"noreferrer noopener\">script<\/a> into your SQL Server database management tool, like SSMS for example. This CUSTOMERS table contains three columns:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>A first column CLIENTID of type int and auto-incremented.<\/li>\n\n\n\n<li>A column NAME of type nvarchar(20) and UNIQUE.<\/li>\n\n\n\n<li>A last column CITY of type nvarchar(20).<\/li>\n<\/ol>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">-- Test if the table CUSTOMERS already exists\n-- And delete it if necessary\nIF EXISTS(\n\tSELECT 1 FROM sys.objects\n\tWHERE  object_id = object_id(N'[dbo].[CUSTOMERS]')\n\t\tAND type in (N'U')\n)\nDROP TABLE [dbo].[CUSTOMERS]\nGO\n\n-- Create the CUSTOMERS table with the column NAME declared as UNIQUE\n-- The UNIQUE keyword defines the column with a unique value\n-- Inserting two customers with the same name is therefore impossible\nCREATE TABLE [dbo].[CUSTOMERS] (\n\t[CLIENTID] int IDENTITY(1,1),\n\t[NAME] nvarchar(20) UNIQUE,\n\t[CITY] nvarchar(20)\n)\nGO\n\n-- Insert data for manipulation examples\nINSERT INTO dbo.CUSTOMERS (NAME, CITY) VALUES ('MAMMADOU', 'Lyon');\nINSERT INTO dbo.CUSTOMERS (NAME, CITY) VALUES ('SERGEI', 'Lyon');\nINSERT INTO dbo.CUSTOMERS (NAME, CITY) VALUES ('CHRISTOPHE', 'Paris');\n\n-- Check inserted rows\nSELECT \t*\nFROM \tdbo.CUSTOMERS;<\/pre>\n\n\n\n<p>Let&#8217;s continue in the direction of learning how to manipulate and store data in a database, in a structured manner. Here is <strong><a href=\"https:\/\/expert-only.com\/en\/t-sql\/create-a-view-with-sql-server\/\">how to create a view from an existing table<\/a><\/strong>. To take it a step further, here is a third sales table that stores all the months in columns. This article explains <a href=\"https:\/\/expert-only.com\/en\/t-sql\/sql-server-pivot-example\/\"><strong>how to convert rows into <strong>columns<\/strong><\/strong> <strong>with a PIVOT SQL query<\/strong><\/a>.<\/p>\n\n\n\n<p>In conclusion, SQL Server offers many data formats, alphanumeric or numeric. To go further, this article explains <strong><a href=\"https:\/\/expert-only.com\/en\/t-sql\/sql-server-alter-table\/\">how to modify a SQL Server table to add or remove columns<\/a><\/strong>, or change column length.<\/p>\n\n\n\n<figure class=\"wp-block-embed aligncenter is-type-wp-embed is-provider-sql-and-it-tutorials wp-block-embed-sql-and-it-tutorials\"><div class=\"wp-block-embed__wrapper\">\nhttps:\/\/expert-only.com\/en\/t-sql\/sql-server-alter-table\/\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Add new sample SQL Server tables using the create table statement and SSMS. Here is an example of a SQL Server Create Table script to create a customer or sales table. This T-SQL code is a Data Definition Language <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/en\/t-sql\/create-table-sql-server\/\" title=\"CREATE TABLE with SQL Server\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":5961,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[454],"tags":[],"class_list":{"0":"post-8992","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-t-sql"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>CREATE TABLE with SQL Server - T-SQL<\/title>\n<meta name=\"description\" content=\"Create Table with SQL Server scripts to insert, update and manage sales or customers information as structured data using T-SQL language.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/en\/t-sql\/create-table-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"CREATE TABLE with SQL Server\" \/>\n<meta property=\"og:description\" content=\"Create Table with SQL Server scripts to insert, update and manage sales or customers information as structured data using T-SQL language.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/en\/t-sql\/create-table-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"SQL and IT Tutorials\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-05-26T04:40:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-07-29T13:13:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2018\/06\/pattern_dark_abstract-BD989403FA0_1920x1080.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Expert-Only\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@expert_only\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\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:\/\/expert-only.com\/en\/t-sql\/create-table-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/create-table-sql-server\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"CREATE TABLE with SQL Server\",\"datePublished\":\"2023-05-26T04:40:00+00:00\",\"dateModified\":\"2023-07-29T13:13:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/create-table-sql-server\/\"},\"wordCount\":539,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/create-table-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2018\/06\/pattern_dark_abstract-BD989403FA0_1920x1080.jpeg\",\"articleSection\":[\"T-SQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/en\/t-sql\/create-table-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/create-table-sql-server\/\",\"url\":\"https:\/\/expert-only.com\/en\/t-sql\/create-table-sql-server\/\",\"name\":\"CREATE TABLE with SQL Server - T-SQL\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/en\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/create-table-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/create-table-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2018\/06\/pattern_dark_abstract-BD989403FA0_1920x1080.jpeg\",\"datePublished\":\"2023-05-26T04:40:00+00:00\",\"dateModified\":\"2023-07-29T13:13:25+00:00\",\"description\":\"Create Table with SQL Server scripts to insert, update and manage sales or customers information as structured data using T-SQL language.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/create-table-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/en\/t-sql\/create-table-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/create-table-sql-server\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2018\/06\/pattern_dark_abstract-BD989403FA0_1920x1080.jpeg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2018\/06\/pattern_dark_abstract-BD989403FA0_1920x1080.jpeg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/en\/t-sql\/create-table-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"en\",\"item\":\"https:\/\/expert-only.com\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"CREATE TABLE with SQL Server\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/en\/#website\",\"url\":\"https:\/\/expert-only.com\/en\/\",\"name\":\"SQL and IT Tutorials\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/en\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/en\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/expert-only.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"CREATE TABLE with SQL Server - T-SQL","description":"Create Table with SQL Server scripts to insert, update and manage sales or customers information as structured data using T-SQL language.","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:\/\/expert-only.com\/en\/t-sql\/create-table-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"CREATE TABLE with SQL Server","og_description":"Create Table with SQL Server scripts to insert, update and manage sales or customers information as structured data using T-SQL language.","og_url":"https:\/\/expert-only.com\/en\/t-sql\/create-table-sql-server\/","og_site_name":"SQL and IT Tutorials","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2023-05-26T04:40:00+00:00","article_modified_time":"2023-07-29T13:13:25+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2018\/06\/pattern_dark_abstract-BD989403FA0_1920x1080.jpeg","type":"image\/jpeg"}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"Written by":"Expert-Only","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/en\/t-sql\/create-table-sql-server\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/t-sql\/create-table-sql-server\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"CREATE TABLE with SQL Server","datePublished":"2023-05-26T04:40:00+00:00","dateModified":"2023-07-29T13:13:25+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/en\/t-sql\/create-table-sql-server\/"},"wordCount":539,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/en\/t-sql\/create-table-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2018\/06\/pattern_dark_abstract-BD989403FA0_1920x1080.jpeg","articleSection":["T-SQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/en\/t-sql\/create-table-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/en\/t-sql\/create-table-sql-server\/","url":"https:\/\/expert-only.com\/en\/t-sql\/create-table-sql-server\/","name":"CREATE TABLE with SQL Server - T-SQL","isPartOf":{"@id":"https:\/\/expert-only.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/en\/t-sql\/create-table-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/en\/t-sql\/create-table-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2018\/06\/pattern_dark_abstract-BD989403FA0_1920x1080.jpeg","datePublished":"2023-05-26T04:40:00+00:00","dateModified":"2023-07-29T13:13:25+00:00","description":"Create Table with SQL Server scripts to insert, update and manage sales or customers information as structured data using T-SQL language.","breadcrumb":{"@id":"https:\/\/expert-only.com\/en\/t-sql\/create-table-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/en\/t-sql\/create-table-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/t-sql\/create-table-sql-server\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2018\/06\/pattern_dark_abstract-BD989403FA0_1920x1080.jpeg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2018\/06\/pattern_dark_abstract-BD989403FA0_1920x1080.jpeg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/en\/t-sql\/create-table-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"en","item":"https:\/\/expert-only.com\/en\/"},{"@type":"ListItem","position":2,"name":"CREATE TABLE with SQL Server"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/en\/#website","url":"https:\/\/expert-only.com\/en\/","name":"SQL and IT Tutorials","description":"","publisher":{"@id":"https:\/\/expert-only.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/en\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/expert-only.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/8992","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/comments?post=8992"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/posts\/8992\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media\/5961"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/media?parent=8992"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/categories?post=8992"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/en\/wp-json\/wp\/v2\/tags?post=8992"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}