dbcli / dbcli/mssql-cli

column truncated - how to increase column width

Open
#539 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
1.4k
Forks
191
PR merge metrics
No merged PRs in 30d

Description

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?

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.