/// <summary>
/// 创建一个函数,获取建表语句
/// </summary>
/// <param name="connStr"></param>
private void createFunction(string connStr)
{
string sqlFunc = "";
sqlFunc += " CREATE PROCEDURE[dbo].[sp_getCreateTableSql_zzx] (@table VARCHAR(100) ) AS BEGIN DECLARE @sql TABLE(s VARCHAR(1000), id INT IDENTITY); ";
sqlFunc += " INSERT INTO @sql(s) VALUES('create table [' + @table + '] ('); ";
sqlFunc += " SELECT A.name AS table_name ,B.name AS column_name ,C.value AS column_description INTO #columnsproperties FROM sys.tables A ";
sqlFunc += " INNER JOIN sys.columns B ON B.object_id = A.object_id LEFT JOIN sys.extended_properties C ON C.major_id = B.object_id ";
sqlFunc += " AND C.minor_id = B.column_id WHERE A.name = @table; ";
sqlFunc += " INSERT INTO @sql(s) SELECT ' [' + a.COLUMN_NAME + '] ' + DATA_TYPE + COALESCE('(' + CAST(CHARACTER_MAXIMUM_LENGTH AS VARCHAR) ";
sqlFunc += " + ')', '') + ' ' + CASE WHEN EXISTS(
SQL server获取建表sql语句 并创建结构相同的数据库表
于 2022-09-15 20:38:44 首次发布
本文介绍了如何查询SQL Server中的建表SQL语句,并利用这些信息创建结构相同的数据库表。首先,列举了查询所有数据库的名称,接着展示了获取当前数据库用户表及其记录数的方法。此外,还提供了检查特定表是否包含建表函数的查询方式。
摘要由CSDN通过智能技术生成