SQL Server uses SET fmtonly on to get table metadata _mssql2005

Sometimes we need to get all the metadata for a table, we might think of it by querying the system table, but this is tedious, and after the SQL Server2005 (included), it provides a simpler operation that returns all the metadata for the table, without row data, which is set fmonly {on| OFF} command. As shown in figure:

If the execution plan (CTRL+M) is opened when executed, the label with the execution plan (as shown above) is not returned.

In this way, in the Browser tab group to open more than one label, does not affect the query tag group, we can write SQL, while looking for information, is not more convenient!