<div>
yes, that sounds like a good start :)
</div>


<div>
Cool Angel... this was easier than working out the data size in a row..lol &nbsp;so this is correct... if so I will award the points... thanks for the link...rgds m
</div>


Cool Angel... this was easier than working out the data size in a row..lol  so this is correct... if so I will award the points... thanks for the link...rgds m

<div>
<div class="content wysiwyg-content">
Hi there,<br />
<br />
&nbsp;I have a heap of tables in a new database that are all blank with some changes dripping in every now and again to the design.<br />
<br />
I want to get the size in bytes of the columns in each table... not the length of the data in the column as there is none. So I need to add up the size of number, size of nvarchar 100 etc for a table. &nbsp;I can only see Avg row size and functions to give me the size of data contained in the row.<br />
<br />
PS.. a nice cursor or something that would take in table names and do this would be cool<br />
<br />
thanks M
</div>
</div>


Hi there,

 I have a heap of tables in a new database that are all blank with some changes dripping in every now and again to the design.

I want to get the size in bytes of the columns in each table... not the length of the data in the column as there is none. So I need to add up the size of number, size of nvarchar 100 etc for a table.  I can only see Avg row size and functions to give me the size of data contained in the row.

PS.. a nice cursor or something that would take in table names and do this would be cool

thanks M

get size of an empty column in oracle

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.