create a table in ssms with python
import pyodbc
conn = pyodbc.connect('Driver={SQL Server};'
'Server=RON\SQLEXPRESS;'
'Database=TestDB;'
'Trusted_Connection=yes;')
cursor = conn.cursor()
cursor.execute('''
CREATE TABLE People
(
Name nvarchar(50),
Age int,
City nvarchar(50)
)
''')
conn.commit()