<div>
SELECT *<br />
INTO YourNewTable<br />
FROM YourExistingTable<br />
WHERE 1=0<br />
<br />
<br />
Will create an empty table called YourNewTable with similar meta data to YourExistingTable
</div>


SELECT *
INTO YourNewTable
FROM YourExistingTable
WHERE 1=0


Will create an empty table called YourNewTable with similar meta data to YourExistingTable

<div>
<div class="content wysiwyg-content">
Im working on creating a table from the meta data stored in someother table. is there any easy or anyway doing this. i tried and gave up. <br />
<br />
here is how metadata table looks like<br />
<br />
TABNAME &nbsp;COLNAME &nbsp;DATATYPE &nbsp; LENGTH<br />
usaall &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; regionid &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;int &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; NULL<br />
usaall &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;region &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;varchar &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;60<br />
usaall &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; account &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;varchar &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; 50<br />
<br />
from the above metadata i want to create a table called USAALL with the columns mentioned.
</div>
</div>


Im working on creating a table from the meta data stored in someother table. is there any easy or anyway doing this. i tried and gave up. 

here is how metadata table looks like

TABNAME  COLNAME  DATATYPE   LENGTH
usaall	        regionid	     int 	     NULL
usaall   	region	         varchar	60
usaall	        account  	varchar	      50

from the above metadata i want to create a table called USAALL with the columns mentioned.

Create table from metadata??

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.