想知道一个表中列的类型

[newman0708]

CREATE TABLE [Notepad] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[content] [nvarchar] (300) COLLATE Chinese_PRC_CI_AS NULL ,
[title] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
[positionx] [int] NULL ,
[positiony] [int] NULL ,
[operator] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[createtime] [datetime] NULL ,
[lastmodify] [datetime] NULL ,
CONSTRAINT [PK_Notepad] PRIMARY KEY CLUSTERED
(
[id]
) ON [PRIMARY]
) ON [PRIMARY]
GO


比如，我想知道表的[content]这一列的类型为什么，应该去获取呢？

返回nvarchar。

讲得越详细越好，我是初学，


谢谢!

[newman0708]

谢谢　LouisXIV(夜游神)　的回复，

[LouisXIV]

You can get it from system tables like the query followed

select b.name from syscolumns a inner join systypes b on a.xtype=b.xtype and a.xusertype=b.xusertype where a.name='content' and a.id=object_id('Notepad')