SQL Questions PART-1

Q How do you fetch schema information of a table in SQL ?
        The following SQL query will fetch schema of a table.

         SELECT * FROM INFORMATION_SCHEMA.COLUMNS
         WHERE TABLE_NAME='Table Name'