Swaminathan K
asked on
Getting tables and columns information in sql server
Hi Team,
Currently , iam woking on Miscrosoft SQL Server database . Iam new to this . I want help on datadictionary views like we have in oracle to capture the table , table column information we have in oracle (user_tables / user_tab_columns).
I was told i can get it using any system stored procedure or some views. But able to find one . Can anyone help me with this information in Microsoft SQL SERVER .
Currently , iam woking on Miscrosoft SQL Server database . Iam new to this . I want help on datadictionary views like we have in oracle to capture the table , table column information we have in oracle (user_tables / user_tab_columns).
I was told i can get it using any system stored procedure or some views. But able to find one . Can anyone help me with this information in Microsoft SQL SERVER .
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Welcome..
ASKER