Get tables list from SQL Server Database as a clean python list of strings

Question

I want the tables in SQL Server DB as a nice comma separated list. I have some code as below.

import pyodbc 
cnxn = pyodbc.connect('Trusted_Connection=yes', 
                     driver = '{ODBC Driver 13 for SQL Server}',
                     server = 'XXXXXX\SQLSERVER', 
                     database = 'AdventureWorks2016CTP3')
sql = "SELECT Distinct TABLE_NAME FROM information_schema.TABLES"

cursor = cnxn.cursor()
cursor.execute(sql)
print(cursor.fetchall())

I want the list to be like

['Address', 'AddressType',.....]

instead of

[('Address', ), ('AddressType', ), .....]

How to get this done.

Keerikkattu Chellappan

@RahulNeekhra I fail to see how this question and the question you linked are same or similar. — Keerikkattu Chellappan
– Keerikkattu Chellappan, Commented Nov 6, 2018 at 16:07

dfundako · Accepted Answer · 2018-11-06 15:48:39Z

1

Looks like the list is returned as a list of single element tuples. You could join them using join() and using the index for the first element for one long string or you could use list comprehension to return them as a single list.

val = [('Table1',),('Table2',),('Table3',)]
table_list = [x[0] for x in val]
table_string = ', '.join([x[0] for x in val])

answered Nov 6, 2018 at 15:48

dfundako

8,3643 gold badges21 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

pythomatic · Accepted Answer · 2018-11-06 15:50:14Z

0

If join() isn't your thing, this is a good time for list comprehension:

table_list = [x[0] for x in val]

Which will return a list like you specified.

answered Nov 6, 2018 at 15:50

pythomatic

6575 silver badges14 bronze badges

Collectives™ on Stack Overflow

Get tables list from SQL Server Database as a clean python list of strings

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest