CODEWITHSUNDEEP
squirrel-sql
user1070440
user1070440

Reputation: 1

Query to get all the column names and their type in Squirrel

I am using Squirrel SQL Client to access derby, sql server servers. I can access all the tables and their data from there. Could you please tell me a query to list all the column names, types with no data in Squirrel?

Upvotes: 0

Views: 4308

Answers (1)

Ofir Farchy
Ofir Farchy

Reputation: 8047

Not that familiar with Squirrel, but generally in SQL you can try: 

SELECT COLUMN_NAME, DATA_TYPE
    FROM INFORMATION_SCHEMA.Columns
    WHERE TABLE_NAME='<YourTableName>'

Upvotes: 2

Related Questions