Tips

　テーブルのスキーマ情報を取得するには

SELECT 
	syscolumns.name as ColumnName,
	syscolumns.isnullable as IsNullable ,
	syscolumns.length As Length,
	syscolumns.collation as Collation,
	systypes.name as TypeName
FROM syscolumns
inner JOIN sysobjects ON syscolumns.id = sysobjects.id 
left join systypes on systypes.xusertype = syscolumns.xtype
WHERE sysobjects.name = N'<テーブル名>';

コメント：

お名前:

(画像の文字列を入力して下さい)