dbcli / mssql-cli

A command-line client for SQL Server with auto-completion and syntax highlighting
BSD 3-Clause "New" or "Revised" License
1.35k stars 192 forks source link

column truncated - how to increase column width #539

Open iateadonut opened 2 years ago

iateadonut commented 2 years ago

I'm trying to get all columns in a comma-separated list:

Select TABLE_SCHEMA, TABLE_NAME
    , Stuff(
        (
        Select ', ' + C.COLUMN_NAME
        From INFORMATION_SCHEMA.COLUMNS As C
        Where C.TABLE_SCHEMA = T.TABLE_SCHEMA
            And C.TABLE_NAME = T.TABLE_NAME
        Order By C.ORDINAL_POSITION
        For Xml Path('')
        ), 1, 2, '') As Columns
From INFORMATION_SCHEMA.TABLES As T
WHERE TABLE_NAME = 'Policies'

But the column is trucated:

-----------------------------------------------------------------------+
                                                                       |
-----------------------------------------------------------------------|
cationReceived, LastNotificationEmail, AppCheckNoClaims, AppCheckSe... |
-----------------------------------------------------------------------+

How can in increase the number of characters displayed in a column?