{"id":2852,"date":"2018-09-13T08:25:51","date_gmt":"2018-09-13T08:25:51","guid":{"rendered":"http:\/\/dbtut.com\/?p=2852"},"modified":"2018-11-24T18:31:12","modified_gmt":"2018-11-24T18:31:12","slug":"what-is-file-table-and-differences-from-file-stream","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/09\/13\/what-is-file-table-and-differences-from-file-stream\/","title":{"rendered":"What is File Table and Differences From File Stream"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>The File Table uses the technology of File Stream. It keeps file system data as a table.<\/p>\n<p>That is, you can access the data on disk from within the database.<\/p>\n<p>Unlike File Stream, it keeps the directory hierarchy in the database.<\/p>\n<p>The schema structure is not defined in the file table. In the file stream, you define the schema structure.<\/p>\n<p>The schema structure occurs automatically and can not be changed.<\/p>\n<p>The file table can also be viewed as a share via windows.<\/p>\n<p>You need to enable Enable FILESTREAM for file I\/O access via Configuration Manager.<\/p>\n<p>By reading the article titled &#8220;<a href=\"http:\/\/dbtut.com\/index.php\/2018\/09\/11\/what-is-file-stream-on-sql-server\/\" target=\"_blank\" rel=\"noopener\">What is File Stream On SQL Server<\/a>&#8220;, you can find out how to make this setting on the configuration manager.<\/p>\n<p>This feature can be enabled at the database level.<\/p>\n<p>In the File Table you can access the file properties (create date, modified date) via the database.<\/p>\n<p>As with File Stream, it allows file directories and files to be queried with tsql.<\/p>\n<p>You can use File Stream and File Table together.<\/p>\n<p>File Table does not support memory-mapped files.<\/p>\n<p>For example, notepad and paint uses memory mapped files.<\/p>\n<p>You can not use these applications with the file table on the same server.<\/p>\n<p>I think we can understand File Table more clearly with an example.<\/p>\n<p>First, create a database named FileTableDB.<\/p>\n<p>To create a database, you can read the article named &#8220;<a href=\"http:\/\/dbtut.com\/index.php\/2018\/08\/01\/how-to-create-a-database-on-sql-server\/\" target=\"_blank\" rel=\"noopener\">How To Create a Database On SQL Server<\/a>&#8220;.<\/p>\n<p>Then you can enable File Stream.<\/p>\n<p>We need to apply the same steps as &#8220;<a href=\"https:\/\/dbtut.com\/index.php\/2018\/09\/11\/what-is-file-stream-on-sql-server\/\" target=\"_blank\" rel=\"noopener\">What is File Stream On SQL Server<\/a>&#8220;.<\/p>\n<p>After we arrive at the table creation section, our steps change.<\/p>\n<p>Right click on the database we created and click New File Table &#8230; as follows.<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/09\/583.png\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>It will give you a script. Instead of using this script, we create our file table using the prepared script as below.<\/p>\n<pre class=\"lang:default decode:true\">CREATE TABLE FileTableExample\u00a0\u00a0 AS FileTable\r\nWITH\r\n(\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 FileTable_Directory =\u00a0\u00a0 'FileTableExample',\r\n\u00a0\u00a0\u00a0\u00a0\u00a0 FileTable_Collate_Filename = database_default\r\n);\r\nGO<\/pre>\n<p>&nbsp;<\/p>\n<p>If you do not specify the NON_TRANSACTED_ACCESS method and DIRECTORY_NAME for the File Table while creating the database, you will get an error like this:<\/p>\n<p><em>Msg 33414, Level 16, State 1, Line 2<\/em><\/p>\n<p><em>FileTable objects require the FILESTREAM database option DIRECTORY_NAME to be non-NULL.<\/em><\/p>\n<p>&nbsp;<\/p>\n<p>To create a FileTable in the database &#8221;, set the DIRECTORY_NAME option to a non-NULL value using ALTER DATABASE.<\/p>\n<p>Or, to set the DIRECTORY_NAME option to NULL, in the database &#8221; disable or drop the existing FileTables.<\/p>\n<p>To resolve this error you should run the following script.<\/p>\n<pre class=\"lang:default decode:true\">--READ_ONLY or OFF options are available for NON_TRANSACTED_ACCESS\r\nALTER DATABASE FileTableDB SET FILESTREAM (NON_TRANSACTED_ACCESS = FULL, DIRECTORY_NAME = N'FileTableExample')<\/pre>\n<p>&nbsp;<\/p>\n<p>If you get an error when you run the script, you can make the following changes on script.<\/p>\n<pre class=\"lang:default decode:true\">ALTER DATABASE FileTableDB SET SINGLE_USER WITH ROLLBACK IMMEDIATE\r\nGO\r\n--READ_ONLY or OFF options are available for NON_TRANSACTED_ACCESS\r\nALTER DATABASE FileTableDB SET FILESTREAM (NON_TRANSACTED_ACCESS = FULL, DIRECTORY_NAME = N'FileTableExample')\r\nGO\r\nALTER DATABASE FileTableDB SET MULTI_USER WITH ROLLBACK IMMEDIATE<\/pre>\n<p>&nbsp;<\/p>\n<p>If you run the script again, you can create your table this time without any errors.<\/p>\n<p>You can query the file table as below.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/09\/544.png\" width=\"385\" height=\"178\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Query will not return a result because it is empty.<\/p>\n<p>If you click on &#8220;Explore File Table Directory&#8221; by right clicking on the file table as below, you will go to the directory created for File Table.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/09\/681.png\" width=\"455\" height=\"171\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>When you create something in this directory and select it again, you will see that you create a row in the table for each folder and file.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/09\/383.png\" width=\"698\" height=\"204\" \/><\/p>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_2852\" class=\"pvc_stats all  \" data-element-id=\"2852\" 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>&nbsp; The File Table uses the technology of File Stream. It keeps file system data as a table. That is, you can access the data on disk from within the database. Unlike File Stream, it keeps the directory hierarchy in the database. The schema structure is not defined in the file table. In the file &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_2852\" class=\"pvc_stats all  \" data-element-id=\"2852\" 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],"tags":[],"class_list":["post-2852","post","type-post","status-publish","format-standard","","category-mssql"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":448,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>What is File Table and Differences From File Stream - Database Tutorials<\/title>\n<meta name=\"description\" content=\"What is File Table and Differences From File Stream\" \/>\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\/2018\/09\/13\/what-is-file-table-and-differences-from-file-stream\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"What is File Table and Differences From File Stream - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"What is File Table and Differences From File Stream\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/09\/13\/what-is-file-table-and-differences-from-file-stream\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-09-13T08:25:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-11-24T18:31:12+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/09\/583.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\/2018\/09\/13\/what-is-file-table-and-differences-from-file-stream\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/13\/what-is-file-table-and-differences-from-file-stream\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"What is File Table and Differences From File Stream\",\"datePublished\":\"2018-09-13T08:25:51+00:00\",\"dateModified\":\"2018-11-24T18:31:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/13\/what-is-file-table-and-differences-from-file-stream\/\"},\"wordCount\":524,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/13\/what-is-file-table-and-differences-from-file-stream\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/09\/583.png\",\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/09\/13\/what-is-file-table-and-differences-from-file-stream\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/13\/what-is-file-table-and-differences-from-file-stream\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/13\/what-is-file-table-and-differences-from-file-stream\/\",\"name\":\"What is File Table and Differences From File Stream - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/13\/what-is-file-table-and-differences-from-file-stream\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/13\/what-is-file-table-and-differences-from-file-stream\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/09\/583.png\",\"datePublished\":\"2018-09-13T08:25:51+00:00\",\"dateModified\":\"2018-11-24T18:31:12+00:00\",\"description\":\"What is File Table and Differences From File Stream\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/13\/what-is-file-table-and-differences-from-file-stream\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/09\/13\/what-is-file-table-and-differences-from-file-stream\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/13\/what-is-file-table-and-differences-from-file-stream\/#primaryimage\",\"url\":\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/09\/583.png\",\"contentUrl\":\"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/09\/583.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/09\/13\/what-is-file-table-and-differences-from-file-stream\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"What is File Table and Differences From File Stream\"}]},{\"@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":"What is File Table and Differences From File Stream - Database Tutorials","description":"What is File Table and Differences From File Stream","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\/2018\/09\/13\/what-is-file-table-and-differences-from-file-stream\/","og_locale":"en_US","og_type":"article","og_title":"What is File Table and Differences From File Stream - Database Tutorials","og_description":"What is File Table and Differences From File Stream","og_url":"https:\/\/dbtut.com\/index.php\/2018\/09\/13\/what-is-file-table-and-differences-from-file-stream\/","og_site_name":"Database Tutorials","article_published_time":"2018-09-13T08:25:51+00:00","article_modified_time":"2018-11-24T18:31:12+00:00","og_image":[{"url":"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/09\/583.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\/2018\/09\/13\/what-is-file-table-and-differences-from-file-stream\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/13\/what-is-file-table-and-differences-from-file-stream\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"What is File Table and Differences From File Stream","datePublished":"2018-09-13T08:25:51+00:00","dateModified":"2018-11-24T18:31:12+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/13\/what-is-file-table-and-differences-from-file-stream\/"},"wordCount":524,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/13\/what-is-file-table-and-differences-from-file-stream\/#primaryimage"},"thumbnailUrl":"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/09\/583.png","articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/09\/13\/what-is-file-table-and-differences-from-file-stream\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/13\/what-is-file-table-and-differences-from-file-stream\/","url":"https:\/\/dbtut.com\/index.php\/2018\/09\/13\/what-is-file-table-and-differences-from-file-stream\/","name":"What is File Table and Differences From File Stream - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/13\/what-is-file-table-and-differences-from-file-stream\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/13\/what-is-file-table-and-differences-from-file-stream\/#primaryimage"},"thumbnailUrl":"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/09\/583.png","datePublished":"2018-09-13T08:25:51+00:00","dateModified":"2018-11-24T18:31:12+00:00","description":"What is File Table and Differences From File Stream","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/13\/what-is-file-table-and-differences-from-file-stream\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/09\/13\/what-is-file-table-and-differences-from-file-stream\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/13\/what-is-file-table-and-differences-from-file-stream\/#primaryimage","url":"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/09\/583.png","contentUrl":"http:\/\/dbtut.com\/wp-content\/uploads\/2018\/09\/583.png"},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/09\/13\/what-is-file-table-and-differences-from-file-stream\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"What is File Table and Differences From File Stream"}]},{"@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\/2852","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=2852"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/2852\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=2852"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=2852"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=2852"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}