{"id":11874,"date":"2019-04-27T14:13:31","date_gmt":"2019-04-27T14:13:31","guid":{"rendered":"https:\/\/dbtut.com\/?p=11874"},"modified":"2019-04-27T14:13:31","modified_gmt":"2019-04-27T14:13:31","slug":"how-to-find-a-column-or-a-word-in-whole-database-in-sql-server","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-find-a-column-or-a-word-in-whole-database-in-sql-server\/","title":{"rendered":"How To Find a Column or a Word in Whole Database in SQL Server"},"content":{"rendered":"

Find a Column Name in Whole Database<\/h2>\n

Sometimes you may want to search for a column name in whole database. Instead of looking all the columns of all the tables one by one, you can use one of the following scripts.<\/p>\n

For example, suppose that we search a column named “phone” in whole database.<\/p>\n

SELECT table_name AS [Table Name], Column_name AS [Column Name] \r\nFROM Information_Schema.Columns where Column_Name like '%Phone%'\r\n\r\nSELECT DISTINCT object_name(object_id) AS [TableName], name AS [Column Name] \r\nFROM sys.columns WHERE name like '%Phone%'\r\n<\/pre>\n
\"\"<\/p>\n
Find a Word in Whole Database<\/h2>\n
Or, you may want to search for a text in the entire database. You can use the following stored procedure for this.<\/p>\n
USE [your_db_name]\r\nGO\r\nCREATE PROC [dbo].[Search_Text_in_Whole_Database]\r\n(\r\n@Search nvarchar(100)\r\n)\r\nAS\r\nBEGIN\r\nCREATE TABLE Result (ColumnName nvarchar(370), ColumnValue nvarchar(3630))\r\nSET NOCOUNT ON\r\nDECLARE @TableName nvarchar(256), @ColumnName nvarchar(128), @Search2 nvarchar(110)\r\nSET @TableName =''\r\nSET @Search2 = QUOTENAME('%' + @Search + '%','''')\r\n\r\nWHILE @TableName IS NOT NULL\r\nBEGIN\r\nSET @ColumnName = ''\r\nSET @TableName = ( SELECT MIN(QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME))\r\nFROM INFORMATION_SCHEMA.TABLES\r\nWHERE TABLE_TYPE = 'BASE TABLE'\r\nAND QUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME) > @TableName\r\nAND OBJECTPROPERTY(\r\nOBJECT_ID(\r\nQUOTENAME(TABLE_SCHEMA) + '.' + QUOTENAME(TABLE_NAME)\r\n), 'IsMSShipped' )\r\n= 0\r\n)\r\nWHILE (@TableName IS NOT NULL) AND (@ColumnName IS NOT NULL)\r\nBEGIN SET @ColumnName = ( SELECT MIN(QUOTENAME(COLUMN_NAME))\r\nFROM INFORMATION_SCHEMA.COLUMNS\r\nWHERE TABLE_SCHEMA = PARSENAME(@TableName, 2)\r\nAND TABLE_NAME = PARSENAME(@TableName, 1)\r\nAND DATA_TYPE IN ('char', 'varchar', 'nchar', 'nvarchar')\r\nAND QUOTENAME(COLUMN_NAME) > @ColumnName )\r\nIF @ColumnName IS NOT NULL\r\nBEGIN\r\nINSERT INTO Result EXEC ( 'SELECT ''' + @TableName + '.' + @ColumnName + ''', LEFT(' + @ColumnName + ', 3630)\r\nFROM ' + @TableName + ' (NOLOCK) ' +\r\n' WHERE ' + @ColumnName + ' LIKE ' + @Search2 )\r\nEND\r\nEND\r\nEND\r\nSELECT ColumnName AS [Table and Column Name], ColumnValue AS [Column Value] FROM Result\r\nEND\r\n\r\nGO<\/pre>\n
After you create the Stored procedure, you can run it as follows. In large databases, you must be careful when running this query. Because all the data in the database will be scanned.<\/p>\n
Lest execute stored procedure on TestDB for searching “Nurullah” in the whole database.<\/p>\n
The query will return all Nurullah values in the database as below.<\/p>\n
USE [TestDB]\r\nGO\r\n[dbo].[Search_Text_in_Whole_Database] 'Nurullah'\r\n<\/pre>\n
\"\"<\/p>\n\n
 <\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"excerpt":{"rendered":"
Find a Column Name in Whole Database Sometimes you may want to search for a column name in whole database. Instead of looking all the columns of all the tables one by one, you can use one of the following scripts. For example, suppose that we search a column named “phone” in whole database. SELECT …<\/p>\n
<\/div>\n
<\/path><\/svg><\/i> \"Loading\"<\/p>\n
<\/div>\n","protected":false},"author":1,"featured_media":11880,"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":[3659,3658,3660,3657,3655,3662,3656,3661,3663,3666,3664,3665,3667],"class_list":["post-11874","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mssql","tag-how-do-i-find-a-column-in-all-tables-in-sql","tag-how-do-i-find-a-particular-column-name-in-sql-server","tag-how-do-i-find-a-value-anywhere-in-a-sql-server-database","tag-how-do-i-search-for-a-word-in-a-database","tag-how-do-i-search-for-a-word-in-an-sql-database","tag-how-to-find-table-name-from-column-value-in-sql-server","tag-how-to-search-sql-server-database-for-string","tag-search-entire-sql-database-for-string","tag-search-for-a-string-in-all-tables-of-sql-server-database","tag-sql-query-to-search-for-a-string-in-a-column","tag-sql-query-to-search-for-a-string-in-a-table","tag-sql-query-to-search-for-a-string-in-all-tables-in-sql-server","tag-sql-to-search-for-a-value-in-all-columns-of-all-tables-in-an-entire-schema"],"aioseo_notices":[],"yoast_head":"\nHow To Find a Column or a Word in Whole Database in SQL Server - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Find a Column or a Word in Whole Database in SQL Server\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-find-a-column-or-a-word-in-whole-database-in-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Find a Column or a Word in Whole Database in SQL Server - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Find a Column or a Word in Whole Database in SQL Server\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-find-a-column-or-a-word-in-whole-database-in-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-04-27T14:13:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-56.png\" \/>\n\t<meta property=\"og:image:width\" content=\"690\" \/>\n\t<meta property=\"og:image:height\" content=\"393\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-find-a-column-or-a-word-in-whole-database-in-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-find-a-column-or-a-word-in-whole-database-in-sql-server\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"How To Find a Column or a Word in Whole Database in SQL Server\",\"datePublished\":\"2019-04-27T14:13:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-find-a-column-or-a-word-in-whole-database-in-sql-server\/\"},\"wordCount\":158,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-find-a-column-or-a-word-in-whole-database-in-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-56.png\",\"keywords\":[\"How do I find a column in all tables in SQL?\",\"How do I find a particular column name in SQL Server?\",\"how do i find a value anywhere in a sql server database?\",\"How do I search for a word in a database?\",\"How do I search for a word in an SQL database?\",\"how to find table name from column value in sql server\",\"How to search sql server database for string\",\"search entire sql database for string\",\"search for a string in all tables of sql server database\",\"sql query to search for a string in a column\",\"sql query to search for a string in a table\",\"sql query to search for a string in all tables in sql server\",\"sql to search for a value in all columns of all tables in an entire schema\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-find-a-column-or-a-word-in-whole-database-in-sql-server\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-find-a-column-or-a-word-in-whole-database-in-sql-server\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-find-a-column-or-a-word-in-whole-database-in-sql-server\/\",\"name\":\"How To Find a Column or a Word in Whole Database in SQL Server - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-find-a-column-or-a-word-in-whole-database-in-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-find-a-column-or-a-word-in-whole-database-in-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-56.png\",\"datePublished\":\"2019-04-27T14:13:31+00:00\",\"description\":\"How To Find a Column or a Word in Whole Database in SQL Server\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-find-a-column-or-a-word-in-whole-database-in-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-find-a-column-or-a-word-in-whole-database-in-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-find-a-column-or-a-word-in-whole-database-in-sql-server\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-56.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-56.png\",\"width\":690,\"height\":393},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-find-a-column-or-a-word-in-whole-database-in-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Find a Column or a Word in Whole Database in SQL Server\"}]},{\"@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":"How To Find a Column or a Word in Whole Database in SQL Server - Database Tutorials","description":"How To Find a Column or a Word in Whole Database in SQL Server","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-find-a-column-or-a-word-in-whole-database-in-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"How To Find a Column or a Word in Whole Database in SQL Server - Database Tutorials","og_description":"How To Find a Column or a Word in Whole Database in SQL Server","og_url":"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-find-a-column-or-a-word-in-whole-database-in-sql-server\/","og_site_name":"Database Tutorials","article_published_time":"2019-04-27T14:13:31+00:00","og_image":[{"width":690,"height":393,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-56.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-find-a-column-or-a-word-in-whole-database-in-sql-server\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-find-a-column-or-a-word-in-whole-database-in-sql-server\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"How To Find a Column or a Word in Whole Database in SQL Server","datePublished":"2019-04-27T14:13:31+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-find-a-column-or-a-word-in-whole-database-in-sql-server\/"},"wordCount":158,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-find-a-column-or-a-word-in-whole-database-in-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-56.png","keywords":["How do I find a column in all tables in SQL?","How do I find a particular column name in SQL Server?","how do i find a value anywhere in a sql server database?","How do I search for a word in a database?","How do I search for a word in an SQL database?","how to find table name from column value in sql server","How to search sql server database for string","search entire sql database for string","search for a string in all tables of sql server database","sql query to search for a string in a column","sql query to search for a string in a table","sql query to search for a string in all tables in sql server","sql to search for a value in all columns of all tables in an entire schema"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-find-a-column-or-a-word-in-whole-database-in-sql-server\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-find-a-column-or-a-word-in-whole-database-in-sql-server\/","url":"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-find-a-column-or-a-word-in-whole-database-in-sql-server\/","name":"How To Find a Column or a Word in Whole Database in SQL Server - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-find-a-column-or-a-word-in-whole-database-in-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-find-a-column-or-a-word-in-whole-database-in-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-56.png","datePublished":"2019-04-27T14:13:31+00:00","description":"How To Find a Column or a Word in Whole Database in SQL Server","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-find-a-column-or-a-word-in-whole-database-in-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-find-a-column-or-a-word-in-whole-database-in-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-find-a-column-or-a-word-in-whole-database-in-sql-server\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-56.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-56.png","width":690,"height":393},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/27\/how-to-find-a-column-or-a-word-in-whole-database-in-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Find a Column or a Word in Whole Database in SQL Server"}]},{"@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\/11874","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=11874"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/11874\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/11880"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=11874"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=11874"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=11874"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}