Get Column Names From Table Sql – Query Examples

Get Column Names From Table Sql

Sql Get Column Names From Table

We can easily learn the names of columns which table name specified. Even, we can learn data types. To learn column names we must write the code below.

TO DOWNLOAD THE SAMPLE LİBRARY DATABASE CLICK

YOU MAY WANT TO SEE OUR ALL EXAMPLES PAGE, THEN CLICK HERE

Result Of The Query

To learn with data types than we can write:


Result Of The Query;

If we want to learn specified types then we can add conditions like below:

Result Of The Query;

The above code, only lists the columns of the table named ‘books’ in the ‘varchar’ data type.

About the author

Thomas Brown

Leave a Comment

%d bloggers like this: