Using a query, a view creates a virtual table whose contents are known. In other terms, a view is a hypothetical table built from a
Author: SHAFI SHAIK
Hi, this is Shafi Shaik, Microsoft Solutions Specialist in Data platform as well as in Data Management & Analytics. I am a certified associate in Oracle SQL*Plus and extensively trained in MongoDB Administration. My current role is Database administration with hands-on expertise in almost all relational databases namely Microsoft SQL Server, MySQL, Oracle SQL*Plus, PostGreSQL & Teradata. I'm also specialized in database development, warehousing, traditional data analysis and Big Data analysis.
ALTER VIEW in SQL Server
In contrast to MySQL and a few other RDBMSs, Microsoft SQL Server allows us to change the VIEW. The VIEW can be modified using ALTER
INNODB_TEMP_TABLE_INFO
InnoDB temporary tables that are currently active in an InnoDB instance are described in the table INNODB TEMP TABLE INFO. The internal InnoDB temporary tables
Create Parameter Group in RDS
The engine configuration settings that are applied to one or more DB instances are contained in DB parameter groups. Only Multi-AZ DB clusters are covered by
MySQL Table Storage Consumption Information
DBAs frequently use metadata data for analysis, capacity planning, and troubleshooting. In MySQL, there are two databases called information schema and performance schema that provide
DROP SYNONYM in SQL Server
An alternative name or alias for a table, view, sequence, or other schema item is known as a synonym in databases. In dynamic SQL, it
Big Data & SQL 