Home » MCQs » Transact-SQL (T-SQL) MCQs

Which of the following commands is used if you want to see the column definition of a particular table?

7. Which of the following commands is used if you want to see the column definition of a particular table?

1. Show _column table name
2. Column table name
3. Exec sp_column table name
4. Sp_column table name

Answer: C) Exec sp_column table name

Explanation:

Exec sp_column table name is the command we use when we want to see the columns definition of a particular table.