How to determinate the data type

[ad]

How can I determinate the data type of a physical table in SQLServer 2005?

 

[RobinS]

I don't think a table has a data type. The fields *in* the table
have data types. Is that what you mean?

Robin S.

 

[Rad [Visual C# MVP]]

How can I determinate the data type of a physical table in SQLServer 2005?

I assume you mean the data type of a column in a physical table

Try this:

sp_columns 'tablename'

 

[William \(Bill\) Vaughn]

There are an number of ways.
a.. Try using Visual Studio Server Explorer to drill into the Table columns.
b.. Try using GetSchema (method on the Connection object) and drill into the meta data
c.. Use SQL Server Management Studio object explorer
d.. Script the table and look at the generated code
All of these are documented in my book.
--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)

 

[ad]

Yes, I want to determinate what datatype of a field in a table.