<div>
<div class="content wysiwyg-content">
sp_columns person<br />
displays table info for table person<br />
<br />
<br />
is there a query so result window=<br />
CREATE TABLE person<br />
&nbsp; &nbsp; &nbsp;( <br />
&nbsp; &nbsp; &nbsp; &nbsp; num &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; INT &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NOT NULL &nbsp;, <br />
&nbsp; &nbsp; &nbsp; &nbsp; firstname &nbsp; &nbsp; &nbsp; &nbsp; VARCHAR(20) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NULL &nbsp;, <br />
&nbsp; &nbsp; &nbsp; &nbsp; lastname &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;VARCHAR(30) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;NULL &nbsp;, &nbsp; &nbsp; &nbsp; &nbsp; <br />
&nbsp; &nbsp; &nbsp; &nbsp; gender_code &nbsp; &nbsp; &nbsp; VARCHAR(1) &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NULL &nbsp;, <br />
&nbsp; &nbsp; &nbsp; &nbsp; birth_dttm &nbsp; &nbsp; &nbsp; &nbsp;DATETIME &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NULL &nbsp;, &nbsp;<br />
&nbsp; &nbsp; &nbsp; &nbsp; inactive_date &nbsp; &nbsp; DATETIME &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; NULL &nbsp;,<br />
&nbsp; &nbsp; &nbsp; &nbsp; CONSTRAINT PK_Person PRIMARY KEY CLUSTERED (num ASC) ON [PRIMARY] <br />
&nbsp; &nbsp; &nbsp;)<br />
GO
</div>
</div>


sp_columns person
displays table info for table person


is there a query so result window=
CREATE TABLE person
     ( 
        num               INT              NOT NULL  , 
        firstname         VARCHAR(20)          NULL  , 
        lastname          VARCHAR(30)          NULL  ,         
        gender_code       VARCHAR(1)           NULL  , 
        birth_dttm        DATETIME             NULL  ,  
        inactive_date     DATETIME             NULL  ,
        CONSTRAINT PK_Person PRIMARY KEY CLUSTERED (num ASC) ON [PRIMARY] 
     )
GO

data in a sql server table

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.