{"id":53084,"date":"2019-04-06T14:42:15","date_gmt":"2019-04-06T09:12:15","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=53084"},"modified":"2021-12-05T21:41:44","modified_gmt":"2021-12-05T16:11:44","slug":"create-schema-in-sap-hana","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/create-schema-in-sap-hana\/","title":{"rendered":"Schema in SAP HANA &#8211; Learn to Create Schema in 6 Easy Steps"},"content":{"rendered":"<p>Moving on with understanding the concepts and capabilities of SAP HANA, we will learn about the schema in this tutorial. Schemas are important when you work on <strong>SAP HANA Studio<\/strong>. We will also discuss the types of schemas in SAP HANA and steps to create a schema in SAP HANA Modeler.<\/p>\n<h3>What is a Schema in SAP HANA?<\/h3>\n<p>A schema is like a container which contains all the different elements or objects of a relational database. The elements of the system reside in the Catalog node of <strong>SAP HANA Information Modeler.<\/strong><\/p>\n<p>Within the Catalog node, the relational SAP HANA database is divided into sub-databases known as schemas. These schemas, acting as logical containers keep all the objects relevant to the database such as tables, views, functions indexes, stored procedures, etc.<\/p>\n<p>In other words, it categorizes all the important information about a database into folders. The schema is created as a transportable design-time file (with extension \u201c.hdbschema\u201d) which is a generally flat file stored in data repositories.<\/p>\n<h3>Components of a Schema in SAP HANA<\/h3>\n<p>Each schema consists of a fixed set of folders containing relevant information:<\/p>\n<ul>\n<li>Column views<\/li>\n<li>EPM Models<\/li>\n<li>EPM Query Sources<\/li>\n<li>Functions<\/li>\n<li>Indexes<\/li>\n<li>Procedures<\/li>\n<li>Sequences<\/li>\n<li>Synonyms<\/li>\n<li>Tables<\/li>\n<li>Triggers<\/li>\n<li>Views<\/li>\n<\/ul>\n<h3>Types of Schemas in SAP HANA<\/h3>\n<p>There are three types of schemas in SAP HANA:<\/p>\n<h4>1. User Defined Schema<\/h4>\n<p>The user-defined schema or custom schemas are created by users such as a HANA DBA, System Administrator or a developer. You can create a user-defined schema using an SQL code.<\/p>\n<p>The syntax for creating such a schema is:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">CREATE SCHEMA &lt;schema_name&gt;;<\/pre>\n<p>Now, if you wish the objects such as tables or views residing under this schema get consumes in other information views or schemas, then you need to grant access at the time of creating a schema.<\/p>\n<p>The syntax for access granting statement is:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">GRANT SELECT ON &lt;schema_name&gt; TO SYS_REPO WITH GRANT OPTION<\/pre>\n<h4>2. System Defined Schema<\/h4>\n<p>The system defined schema contains SAP HANA system information and is created with the SAP HANA database by a system.<\/p>\n<p>There are standard system defined schemas such as _SYS_BIC, _SYS_REPO, _SYS_BI, _SYS_STATISTICS, _SYS_XS, etc. Each of this system defined schema contains information relevant to specific system aspects.<\/p>\n<ul>\n<li>_SYS_BIC: Contains column views of all the activated objects.<\/li>\n<li>_SYS_REPO: Contains all the objects available in the repository such as activated objects, inactive objects, runtime objects, package details, etc.<\/li>\n<li>_SYS_BI: Contains the metadata for the column views.<\/li>\n<li>_SYS_STATISTICS: Contains information regarding system configuration and parameters.<\/li>\n<li>_SYS_XS: Contains data related to SAP HANA Extended Applications Services.<\/li>\n<\/ul>\n<h4>3. SLT Driven Schema<\/h4>\n<p>This schema is created when SLT is configured to carry out replication of tables. It will contain all the tables that replicate into SAP HANA through SLT. Such schemas create on Data Provisioning by SLT process.<\/p>\n<h3>How to Create Schema in SAP HANA Modeler?<\/h3>\n<p>We can create schemas in SAP HANA in two ways:<\/p>\n<p>1. By creating a user which automatically creates a schema for that user.<\/p>\n<p>2. Another method is by creating a customized schema under an existing user without creating a new user.<\/p>\n<p>Below are the steps to create a customized schema:<\/p>\n<p><strong>Step 1:<\/strong> Open the SQL Console in SAP HANA Modeler.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SQL-Console-in-SAP-HANA-Modeler.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-53117\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SQL-Console-in-SAP-HANA-Modeler.jpg\" alt=\"Schema - SQL Console in SAP HANA Modeler\" width=\"1900\" height=\"891\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SQL-Console-in-SAP-HANA-Modeler.jpg 1900w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SQL-Console-in-SAP-HANA-Modeler-150x70.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SQL-Console-in-SAP-HANA-Modeler-300x141.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SQL-Console-in-SAP-HANA-Modeler-768x360.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SQL-Console-in-SAP-HANA-Modeler-1024x480.jpg 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SQL-Console-in-SAP-HANA-Modeler-520x244.jpg 520w\" sizes=\"auto, (max-width: 1900px) 100vw, 1900px\" \/><\/a><\/p>\n<p><strong>Step 2:<\/strong>\u00a0After that, the SQL Console is ready for you to enter the <strong>SQL statement<\/strong>.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SQL-Statement-Option.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-53120\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SQL-Statement-Option.jpg\" alt=\"Schema - SQL Statement Option\" width=\"1914\" height=\"957\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SQL-Statement-Option.jpg 1914w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SQL-Statement-Option-150x75.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SQL-Statement-Option-300x150.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SQL-Statement-Option-768x384.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SQL-Statement-Option-1024x512.jpg 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/SQL-Statement-Option-520x260.jpg 520w\" sizes=\"auto, (max-width: 1914px) 100vw, 1914px\" \/><\/a><\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">CREATE SCHEMA TEST_SCHEMA OWNED BY TRAINER<\/pre>\n<p>Enter the SQL statement to create a schema. In the image shown below, the schema named TEST_SCHEMA will create which a pre-existing user, TRAINER, owns<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Schema-named-TEST_SCHEMA-.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-53122\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Schema-named-TEST_SCHEMA-.jpg\" alt=\"Schema named TEST_SCHEMA\" width=\"1623\" height=\"921\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Schema-named-TEST_SCHEMA-.jpg 1623w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Schema-named-TEST_SCHEMA--150x85.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Schema-named-TEST_SCHEMA--300x170.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Schema-named-TEST_SCHEMA--768x436.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Schema-named-TEST_SCHEMA--1024x581.jpg 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Schema-named-TEST_SCHEMA--520x295.jpg 520w\" sizes=\"auto, (max-width: 1623px) 100vw, 1623px\" \/><\/a><\/p>\n<p><strong>Step 3:<\/strong> To execute this statement, select the statement written and click on the green execute icon (indicated by the red arrow). You can use keyboard shortcut F8 for this.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Green-Execute-icon.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-53135\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Green-Execute-icon.jpg\" alt=\"Schema - Green Execute icon\" width=\"1605\" height=\"913\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Green-Execute-icon.jpg 1605w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Green-Execute-icon-150x85.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Green-Execute-icon-300x171.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Green-Execute-icon-768x437.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Green-Execute-icon-1024x582.jpg 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Green-Execute-icon-520x296.jpg 520w\" sizes=\"auto, (max-width: 1605px) 100vw, 1605px\" \/><\/a><\/p>\n<p>A message at the bottom of the console will confirm successful execution.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Message-at-bottom-of-console.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-53136\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Message-at-bottom-of-console.jpg\" alt=\"Schema - Message at bottom of console\" width=\"1057\" height=\"147\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Message-at-bottom-of-console.jpg 1057w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Message-at-bottom-of-console-150x21.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Message-at-bottom-of-console-300x42.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Message-at-bottom-of-console-768x107.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Message-at-bottom-of-console-1024x142.jpg 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Message-at-bottom-of-console-520x72.jpg 520w\" sizes=\"auto, (max-width: 1057px) 100vw, 1057px\" \/><\/a><\/p>\n<p><strong>Step 4:<\/strong>\u00a0Then, to find the newly created schema, refresh the Catalog.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Refresh-Option-in-Catalog.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-53144\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Refresh-Option-in-Catalog.jpg\" alt=\"Schema - Refresh Option in Catalog\" width=\"794\" height=\"358\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Refresh-Option-in-Catalog.jpg 794w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Refresh-Option-in-Catalog-150x68.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Refresh-Option-in-Catalog-300x135.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Refresh-Option-in-Catalog-768x346.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Refresh-Option-in-Catalog-520x234.jpg 520w\" sizes=\"auto, (max-width: 794px) 100vw, 794px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong>Step 5:<\/strong> After that, the schema will add.<\/p>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Added-Schema.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-53141\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Added-Schema.jpg\" alt=\"Added Schema\" width=\"887\" height=\"605\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Added-Schema.jpg 887w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Added-Schema-150x102.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Added-Schema-300x205.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Added-Schema-768x524.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Added-Schema-520x355.jpg 520w\" sizes=\"auto, (max-width: 887px) 100vw, 887px\" \/><\/a><\/p>\n<p>Also, if you go and check the list of users, no new user is added.<\/p>\n<p><strong>Step 6:<\/strong>\u00a0Then, you can also drop the table by writing a small code as shown below.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">CREATE SCHEMA TEST_SCHEMA OWNED BY TRAINER \r\n\r\nDROP SCHEMA TEST_SCHEMA<\/pre>\n<p><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Code-for-dropping-table.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-53147\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Code-for-dropping-table.jpg\" alt=\"Schema - Code for dropping table\" width=\"970\" height=\"647\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Code-for-dropping-table.jpg 970w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Code-for-dropping-table-150x100.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Code-for-dropping-table-300x200.jpg 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Code-for-dropping-table-768x512.jpg 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Code-for-dropping-table-520x347.jpg 520w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Code-for-dropping-table-272x182.jpg 272w\" sizes=\"auto, (max-width: 970px) 100vw, 970px\" \/><\/a><\/p>\n<h3>Summary<\/h3>\n<p>This concludes our lesson on SAP HANA Schema. A schema is an important structural component of SAP HANA database and gives a logical framework to users. In the next segment, we will talk about a component of the schema in <strong>SAP HANA<\/strong>; tables.<\/p>\n<p>Are you clear with the concept of Schema in SAP HANA? If you have any queries, just enter in the comment section.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Moving on with understanding the concepts and capabilities of SAP HANA, we will learn about the schema in this tutorial. Schemas are important when you work on SAP HANA Studio. We will also discuss&#46;&#46;&#46;<\/p>\n","protected":false},"author":6,"featured_media":53159,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18002],"tags":[19377,19375,19376,19378],"class_list":["post-53084","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sap-hana","tag-create-schema-in-sap-hana","tag-schema-in-sap-hana","tag-types-of-schemas","tag-what-is-a-schema"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Schema in SAP HANA - Learn to Create Schema in 6 Easy Steps - DataFlair<\/title>\n<meta name=\"description\" content=\"Learn to create schema in SAP HANA in easy steps. Understand the concept of schemas and different types of schemas in SAP HANA.\" \/>\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\/create-schema-in-sap-hana\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Schema in SAP HANA - Learn to Create Schema in 6 Easy Steps - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Learn to create schema in SAP HANA in easy steps. Understand the concept of schemas and different types of schemas in SAP HANA.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/create-schema-in-sap-hana\/\" \/>\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=\"2019-04-06T09:12:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-05T16:11:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Schema-in-SAP-HANA.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=\"5 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Schema in SAP HANA - Learn to Create Schema in 6 Easy Steps - DataFlair","description":"Learn to create schema in SAP HANA in easy steps. Understand the concept of schemas and different types of schemas in SAP HANA.","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\/create-schema-in-sap-hana\/","og_locale":"en_US","og_type":"article","og_title":"Schema in SAP HANA - Learn to Create Schema in 6 Easy Steps - DataFlair","og_description":"Learn to create schema in SAP HANA in easy steps. Understand the concept of schemas and different types of schemas in SAP HANA.","og_url":"https:\/\/data-flair.training\/blogs\/create-schema-in-sap-hana\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2019-04-06T09:12:15+00:00","article_modified_time":"2021-12-05T16:11:44+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Schema-in-SAP-HANA.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":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/create-schema-in-sap-hana\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/create-schema-in-sap-hana\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"Schema in SAP HANA &#8211; Learn to Create Schema in 6 Easy Steps","datePublished":"2019-04-06T09:12:15+00:00","dateModified":"2021-12-05T16:11:44+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/create-schema-in-sap-hana\/"},"wordCount":728,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/create-schema-in-sap-hana\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Schema-in-SAP-HANA.jpg","keywords":["Create Schema in SAP HANA","Schema in SAP HANA","Types of Schemas","What is a Schema?"],"articleSection":["SAP HANA Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/create-schema-in-sap-hana\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/create-schema-in-sap-hana\/","url":"https:\/\/data-flair.training\/blogs\/create-schema-in-sap-hana\/","name":"Schema in SAP HANA - Learn to Create Schema in 6 Easy Steps - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/create-schema-in-sap-hana\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/create-schema-in-sap-hana\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Schema-in-SAP-HANA.jpg","datePublished":"2019-04-06T09:12:15+00:00","dateModified":"2021-12-05T16:11:44+00:00","description":"Learn to create schema in SAP HANA in easy steps. Understand the concept of schemas and different types of schemas in SAP HANA.","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/create-schema-in-sap-hana\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/create-schema-in-sap-hana\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/create-schema-in-sap-hana\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Schema-in-SAP-HANA.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2019\/03\/Schema-in-SAP-HANA.jpg","width":1200,"height":628,"caption":"Schema in SAP HANA"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/create-schema-in-sap-hana\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"SAP HANA Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/sap-hana\/"},{"@type":"ListItem","position":3,"name":"Schema in SAP HANA &#8211; Learn to Create Schema in 6 Easy Steps"}]},{"@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\/53084","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=53084"}],"version-history":[{"count":13,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/53084\/revisions"}],"predecessor-version":[{"id":105073,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/53084\/revisions\/105073"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/53159"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=53084"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=53084"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=53084"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}