INFORMATION_SCHEMA.VIEW_COLUMN_USAGE alias column name

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246986 More actions · Answer 1

I've had a quick look, but can't find where this alias is appearing - please direct me to it!

Phil

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

Amrita bhatia Right there with Babe Points: 718 More actions · Answer 2

this is the actual view used

create view Invoices AS

SELECT Orders.ShipName, Orders.ShipAddress, Orders.ShipCity, Orders.ShipRegion, Orders.ShipPostalCode,

Orders.ShipCountry, Orders.CustomerID, Customers.CompanyName AS CustomerName, Customers.Address, Customers.City,

Customers.Region, Customers.PostalCode, Customers.Country,

(FirstName + ' ' + LastName) AS Salesperson,

Orders.OrderID, Orders.OrderDate, Orders.RequiredDate, Orders.ShippedDate, Shippers.CompanyName As ShipperName,

"Order Details".ProductID, Products.ProductName, "Order Details".UnitPrice, "Order Details".Quantity,

"Order Details".Discount,

(CONVERT(money,("Order Details".UnitPrice*Quantity*(1-Discount)/100))*100) AS ExtendedPrice, Orders.Freight

FROM Shippers INNER JOIN

(Products INNER JOIN

(

(Employees INNER JOIN

(Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID)

ON Employees.EmployeeID = Orders.EmployeeID)

INNER JOIN "Order Details" ON Orders.OrderID = "Order Details".OrderID)

ON Products.ProductID = "Order Details".ProductID)

ON Shippers.ShipperID = Orders.ShipVia

so wen we use

SELECT TABLE_NAME,COLUMN_NAME FROM INFORMATION_SCHEMA.VIEW_COLUMN_USAGE WHERE

VIEW_NAME = 'invoices' ORDER BY 1 on it

it gives table name shippers and column name as companyname

we need both the shippername and companyname

ny suggesstions?

amrita

Markus Feirer Valued Member Points: 73 More actions · Answer 3

Hello,

Did anyone find a answer of that question?

Regards Markus