Teradata Studio: How to change query font size in SQL Editor?
If you need, you can easily change font size in Teradata Studio for Query, Answerset or History window. Increasing or decreasing font size in Teradata Studio can quickly improve your…
How to use Pivot SQL function in Microsoft SQL Server
Sometimes you got business requirements to create new view or dashboard and to do this you need to convert rows to columns. You can transpose them on two ways: using…
Teradata: How to convert rows to columns? Pivot function at Teradata.
Sometimes you got business requirments to create new view or dashboard and to do this you need to convert rows to columns. You can transpose them on two ways: using…
Teradata: What is the difference between CASESPECIFIC and NOT CASESPECIFIC data type attributes?
When you create tables, you can set a lot of data type attribues like CHARACTER SET, FORMAT, UPPERCASE or (NOT) CASESPECIFIC. CASESPECIFIC attribute specifies case for character data comparisons and…
Oracle Database: How to check if the table has a primary key. Types of constraints
A constraint is a rule that you define and its task is to protect the table from clutter that may arise as a result of adding incorrect or incomplete data.…
How to run Microsoft SQL Server database using docker and docker-compose
In this post I will show you how you can easily run Microsoft SQL Server Database using docker and docker-compose. Microsoft provides official images in docker hub, so you can…
Data migration – conversion of data types from MS SQL Server to Teradata
Data migration between two different database systems always involves the conversion of data types. In this post, I will introduce the concept of data migration and show how to convert…
Teradata: Failure 7547 Target row updated by multiple source rows
You will get this error code when try update the target table using multiple records from source. It completely does not matter if you use MERGE or direct UPDATE statement.…
![Read more about the article [SOLVED] Teradata: Error 3854 [SQLState HY000] <your object name> is not a view.](https://bigdata-etl.com/wp-content/uploads/2019/12/Untitled-1-300x180.png)
[SOLVED] Teradata: Error 3854 [SQLState HY000] <your object name> is not a view.
In this post I will explain why you encountered an error [Error 3854] [SQLState HY000] <your object name> is not a view while executing the DDL query at Teradata, what…
SQL Server: How to check column data types in SQL Server database?
There are at least a few ways to get column data types in Microsoft SQL Server database. In this short post, I will show you two the most popular ways…