question

kore.sid avatar image
kore.sid asked

SQL server view metadata information

I have a table as below, create table employee_details ( id int, name varchar(10) ) And below view is on employee_details create view vw_empl_details as select id as emp_id,name as emp_name from employee_details I want to know which system table keeps track of column wise information for above condition.. id-> emp_id name-> emp_name we have below 2 tables to keep track of tables but not sure columnwise information is available in sql server select * from [INFORMATION_SCHEMA].[VIEW_COLUMN_USAGE] select * from [INFORMATION_SCHEMA].VIEW_TABLE_USAGE
sql serverviews
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.