Breaking News: Grepper is joining You.com. Read the official announcement!

list-table-columns- in-sql-server

irfan akunkerja answered on November 11, 2022 Popularity 6/10 Helpfulness 4/10

answer list-table-columns- in-sql-server

list-table-columns- in-sql-server

Comment

select schema_name(tab.schema_id) as schema_name,
    tab.name as table_name, 
    col.column_id,
    col.name as column_name, 
    t.name as data_type,    
    col.max_length,
    col.precision
from sys.tables as tab
    inner join sys.columns as col
        on tab.object_id = col.object_id
    left join sys.types as t
    on col.user_type_id = t.user_type_id
order by schema_name,
    table_name, 
    column_id;

Popularity 6/10 Helpfulness 4/10 Language sql

Source: dataedo.com

Tags: sql

Link to this answer
Share Copy Link

Contributed on Nov 11 2022

irfan akunkerja

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

list-table-columns- in-sql-server

Contents

More Related Answers

list-table-columns- in-sql-server

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.