`%sqlcmd columns` outputs sql.inspect.Columns

[prakashperiasamy]

Hi Objective: Using the %sqlcmd columns I like to access the column names (as a dataframe or series or list) of tables in a database.

What I did: Cell#1: %sql USE DATABASE {DB Name} %sqlcmd columns --table {Table Name} --schema {Schema Name}

Cell#2: (to capture the previous result) df = _ Cell#3: (to know the data type of the result) type(df) output: sql.inspect.Columns

Hence I'm not able to apply any methods or functions to convert this into a dataframe or series or list.

Q1: Is there a way I can access the output as a dataframe instead of sql.inspect.Columns Q2: Is there a way to consolidate cell#1 & 2. Is there a way to directly store the output of %sqlcmd into a variable directly.