Reg:Extract View information in Sql server
-
Hi, I have a view. i want to get the columns in a view along with its database and servername. For example, Employee table resides in CSCEmp server's Emp database. I have a view in CSCDet server that will have a column "EmpName" of [CSCEmp's] Employee table. When i list view information, i want to display like view view'sserver Columnname column'sServer EMPView CSCDet EmpName CSCEmp Is there a way to do like this. Thanks.
-
Hi, I have a view. i want to get the columns in a view along with its database and servername. For example, Employee table resides in CSCEmp server's Emp database. I have a view in CSCDet server that will have a column "EmpName" of [CSCEmp's] Employee table. When i list view information, i want to display like view view'sserver Columnname column'sServer EMPView CSCDet EmpName CSCEmp Is there a way to do like this. Thanks.
Look into the information schema views (under system views in management studio) or sysobjects in 2k. These will give you all the information about SQLs internal structures.
Never underestimate the power of human stupidity RAH