E-mail Print PDF 

CREATE VIEW view_name AS
SELECT column_name(s)
FROM table_name
WHERE condition

Note - Note: 

1
2
3
4

CREATE VIEW [Current Product List] AS
SELECT ProductID,ProductName
FROM Products
WHERE Discontinued=No
 

1

SELECT * FROM []
 

1
2
3
4

CREATE OR REPLACE VIEW view_name AS
SELECT column_name(s)
FROM table_name
WHERE condition
 

1
2
3
4

CREATE VIEW [Current Product List] AS
SELECT ProductID,ProductName,Category
FROM Products
WHERE Discontinued=No

удаляется с помощью запроса DROP VIEW.

1

DROP VIEW view_name

Comments

 
+1 #1 Константин 2010-05-04 07:06 The first word "representation" missing "D" Quote
 
 
+2 #2 Lvbnhbq 2010-09-03 15:05 th data! Quote
 
 
+1 #3 qe4ugferwf 2011-10-30 20:03 Quote
 
 
0 #4 FOd 2011-12-26 22:12






Quote
 

Authorization

Nice Ajax Poll

Which one of my extensions is the best?

Statistics

Translate

русскийitalianoDeutschEnglishLATVIANукраїнськаfrançaispolski
1

Advertisement


Официальный курс валют ЦБ РФ ; Мягкая мебель для вашего дома: мебель. ; Веселые игровые автоматы у нас.

© 2009 ageent.ru.