list sql server data types

hello,

im trying to make an we application, that from it i can create a database and table to the server

i created the database.

but i want to create the tables too, but the problem is how can i list the data types of the sql server in the aspx page so i can create the tables with columns of requuired types.

Kind Regards

Mahmoud ManasrahI believe you could use the collection System.Data.SQLTypes. I don't know that you could bind directly to the collection, but you could iterate through it adding it to a bindable object (like a dataset for instance). HTH|||thank you

its a cool idea, this is what i was looking for

but im trying to do the code to iterate through this collection, but still didnt reach it

can u tell me how can i write the code

Kind Regards|||How about
foreach(Object myType in System.Data.SqlTypes)
if (myType.GetType().Name.Substring(0,3) == "Sql")

I haven't tested this, just maybe a starting point.

List of SQL Server Proprietary Data Types?

Could someone point me to a list of SQL Server proprietary data types? Tried
searching this forum and the web but couldn't find a full published list.
Thanks.
NaveenTry,
select [name]
from master.dbo.systypes
go
AMB
"Naveen" wrote:

> Could someone point me to a list of SQL Server proprietary data types? Tri
ed
> searching this forum and the web but couldn't find a full published list.
> Thanks.
> Naveen|||That seems to be a list of all data types in SQL Server. I should have been
more clear. I meant non-ANSI compliant datatypes in SQL Server.
"Alejandro Mesa" wrote:
> Try,
> select [name]
> from master.dbo.systypes
> go
>
> AMB
> "Naveen" wrote:
>|||So, get a list of ANSI data types, and say:
SELECT [name] FROM master.dbo.systypes
WHERE [name] NOT IN ('type1', 'type2', etc)
Obviously, SQL Server doesn't have a flag called ANSI_COMPLIANT...
A
"Naveen" <Naveen@.discussions.microsoft.com> wrote in message
news:67059C80-35BA-4251-AB3F-0E442E582F2A@.microsoft.com...
> That seems to be a list of all data types in SQL Server. I should have
> been
> more clear. I meant non-ANSI compliant datatypes in SQL Server.
> "Alejandro Mesa" wrote:
>|||Some info here:
http://www.karaszi.com/SQLServer/in...i_datatypes.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Naveen" <Naveen@.discussions.microsoft.com> wrote in message
news:498D2709-8186-4F4D-88E1-9B5CAACA3D65@.microsoft.com...
> Could someone point me to a list of SQL Server proprietary data types? Tri
ed
> searching this forum and the web but couldn't find a full published list.
> Thanks.
> Naveen

List of new supported datatypes

Is there a list of new supported data types for SQL 2005 anywhere?

Thanks
MoonWaYou can take a look at <a href="http://links.10026.com/?link=http://msdn2.microsoft.com/ms187752.aspx">this</a>.And John Bell wrote a nice text on the microsoft.public.sqlserver.programming newsgroep:

DataTypes - UDTs, the XML data type, and "MAX" BLOBs and CLOBs SQL Server 2005 adds support for user-defined types, a native XML data type and better large data support. Large data support is improved by using the Transact-SQL types VARCHAR(MAX), NVARCHAR(MAX) and VARBINARY(MAX). User-defined types and a native XML type are defined by the SQL:1999 and SQL:2003 specifications. To use these data types with SqlClient, new classes in the System.Data.SqlTypes namespace are defined (SqlUdt and SqlXml), support is added to the SqlDbTypes enumeration and IDataReader.GetValue was enhanced to support returning UDTs as .NET Object types, and support returning XML as a .NET String. These new SQL Server 2005 types are supported in DataReaders returned from SQL SELECT statements and as Parameters using SqlParameter. A special class, SqlMetaData, can return information about extended properties of these new data types, such as the XML schema collection that a strongly typed XML column adheres to, or the database name of a UDT. You can use these types from the client directly, in generic code, and also in the DataSet. Finally you can perform partial updates on the "MAX" data types from the client, which required using special SQL functions before ADO.NET 2.0.

List CRM entity attributes and data types

Hi,

I am using CRM 3.0 and have a requirement to list all the the tables, attributes names and display names and datatypes. Is there any easy way to export this information from the CRM tool or prepare a SQL query that will list the information?

You are kind of in the wrong neck of the woods, but I will try to give you a bit of help (there is a page here to go to the Microsoft Dynamics newsgroups http://www.microsoft.com/dynamics/community/newsgrouplanding.mspx)

Most of this information is available in the METABASE database in the entity and attribute tables. Not 100% sure if the display names are exactly right. They might actually be maintained in an ugly XML document.

|||Use CRM Meta Webservices. You can use the CRM SDK to get info on methods that would do this.