0

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?

Nakilon
  • 34,866
  • 14
  • 107
  • 142
user1070440
  • 1
  • 1
  • 1

1 Answers1

2

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>'
Ofir Farchy
  • 7,657
  • 7
  • 38
  • 58