Top "Sql-view" questions

Error creating MySQL view in phpMyAdmin

I'm having a hard time trying to create a view in phpMyAdmin. I have a database named myDB and a …

mysql phpmyadmin sql-view

MySQL - create view using subquery in FROM clause

I want to create view in MySQL using a subquery CREATE OR REPLACE VIEW `V_TASK_TRANSFER` (`REF_ID`, `DATE_…

mysql sql subquery sql-view

Generate id row for a view with grouping

I'm trying to create a view with row numbers like so: create or replace view daily_transactions as select generate_…

sql postgresql view window-functions sql-view

add column to a view in Oracle Designer

I have a view in Oracle designer which I'd like to add a column to. I've tried Create columnand input …

oracle view sql-view

Change PostgreSQL columns used in views

I would like PostegreSQL to relax a bit. Every time I want to change a column used in a view, …

sql postgresql types varchar sql-view

Performing string concatenation from rows of data in a TSQL view (pivot?)

I'd like to create a view in SQL Server that combines several pieces of database metadata. One piece of metadata …

sql sql-server-2005 concatenation sql-view

Update/Insert into View wia Trigger

It occurred in my project that I had to extend an existing table with a few more columns. Unfortunately I …

sql triggers sql-server-2012 sql-view

How much space does a view take up in Microsoft SQL Server

I have a very large table in SQL Server 2008. It has lots of fields which are only useful to a …

sql-server sql-view

Difference between SQL View and WITH clause

Can anybody in here tell me the difference of VIEW and WITH, as I have searched many placed and I …

sql sql-view

Check if a given DB object used in Oracle?

Hi does any one know how to check if a given DB object (Table/View/SP/Function) is used inside …

sql oracle stored-procedures function sql-view