怎样用程序或者SQL语句实现表结构的生成?包括主键,外键关联以及约束等关系也要生成
解决方案 »
- 问个系统日期和时间的个性化问题吧,格式化方面的
- c# 关于多态性的问题
- [Win]水晶报表的详情 如何横向显示,并换行
- RowDataBound()问题,大家帮忙!!!
- HttpApplication.PreRequestHandlerExecute方法可以拦截那些请求
- 如何在程序中实现保存一个网页,相当于ie的另存功能。
- 请问大家怎样在B/S结构中用C#实现菜单功能,各位有经验的朋友能帮助解决吗?
- 好长时间不搞技术了,闹心!接分~~~
- WPF,引用资源的问题?
- 装箱、拆箱、ConvertToString、 ToString() 的效率问题
- 简单问题:存储过程返回记录!
- C# 嵌入图片到程序里面 。然后怎么在获取?急,在线等待~up~!也给分。。
this._mDa = new SqlDataAdapter(_sqlstrr,this._mConn);
this._mDa.Fill(this._mDs,"PersonInfo");DataSet ds = new DataSet();
ds = this._mDs.Clone();//_mDs为当前数据源
@TableName varchar(50)
AS
SELECT
(case when a.colorder=1 then d.name else '' end) N'TableName',
a.colorder N'字段序号',
a.name N'ColName',
(case when COLUMNPROPERTY( a.id,a.name,'IsIdentity')=1 then '√'else '' end) N'Identity',
(case when (SELECT count(*)
FROM sysobjects
WHERE (name in
(SELECT name
FROM sysindexes
WHERE (id = a.id) AND (indid in
(SELECT indid
FROM sysindexkeys
WHERE (id = a.id) AND (colid in
(SELECT colid
FROM syscolumns
WHERE (id = a.id) AND (name = a.name))))))) AND
(xtype = 'PK'))>0 then '√' else '' end) N'PrimaryKey',
b.name N'DataType',
a.length N'占用字节数',
COLUMNPROPERTY(a.id,a.name,'PRECISION') as N'Length',
isnull(COLUMNPROPERTY(a.id,a.name,'Scale'),0) as N'Scale',
(case when a.isnullable=1 then '√'else '' end) N'KongZhi',
isnull(e.text,'') N'Default',
isnull(g.[value],'') AS N'Description'
FROM syscolumns a left join systypes b
on a.xtype=b.xusertype
inner join sysobjects d
on a.id=d.id and d.xtype in ('U','V') and d.name<>'dtproperties' and d.name=@TableName
left join syscomments e
on a.cdefault=e.id
left join sysproperties g
on a.id=g.id AND a.colid = g.smallid
order by object_name(a.id),a.colorderGO
可以自己写存储过程如ls,
或者干脆用数据库生成sql脚本即可
drop table [dbo].[PsnInfo]
GOif exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PsnDetail]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[PsnDetail]
GOCREATE TABLE [dbo].[PsnInfo] (
[PersonID] [int] NOT NULL ,
[PersonName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[PersonAddress] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[PSex] [bit] NULL ,
[PAge] [int] NULL ,
[Preal] [real] NULL
) ON [PRIMARY]
GOCREATE TABLE [dbo].[PsnDetail] (
[PersonID] [int] NULL ,
[aa] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[bb] [nchar] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GOALTER TABLE [dbo].[PsnInfo] WITH NOCHECK ADD
CONSTRAINT [PK_PerInfo] PRIMARY KEY CLUSTERED
(
[PersonID]
) ON [PRIMARY]
GO