婷婷综合国产,91蜜桃婷婷狠狠久久综合9色 ,九九九九九精品,国产综合av

主頁(yè) > 知識(shí)庫(kù) > 獲取SQL Server表字段的各種屬性實(shí)例代碼

獲取SQL Server表字段的各種屬性實(shí)例代碼

熱門標(biāo)簽:美團(tuán)地圖標(biāo)注商戶認(rèn)證注冊(cè) 慶陽(yáng)地圖標(biāo)注 咸陽(yáng)電腦外呼系統(tǒng)運(yùn)營(yíng)商 榕城市地圖標(biāo)注 承德地圖標(biāo)注公司名需要花錢嗎 怎么給高德做地圖標(biāo)注 浙江穩(wěn)定外呼系統(tǒng)供應(yīng)商 電銷外呼系統(tǒng)軟件功能 北京400電話辦理多少錢

復(fù)制代碼 代碼如下:

-- SQL Server 2000
SELECT a.name AS 字段名, CASE WHEN EXISTS
(SELECT 1
FROM sysobjects
WHERE xtype = 'PK' AND parent_obj = a.id AND name IN
(SELECT name
FROM sysindexes
WHERE indid IN
(SELECT indid
FROM sysindexkeys
WHERE id = a.id AND colid = a.colid)))
THEN '1' ELSE '0' END AS 主鍵, CASE WHEN COLUMNPROPERTY(a.id, a.name,
'IsIdentity') = 1 THEN '1' ELSE '0' END AS 標(biāo)識(shí), b.name AS 類型,
a.length AS 占用字節(jié)數(shù), COLUMNPROPERTY(a.id, a.name, 'PRECISION') AS 長(zhǎng)度,
a.xscale AS 小數(shù), a.isnullable AS 可空, ISNULL(e.text, '') AS 默認(rèn)值, ISNULL(g.[value],
'') AS 字段說明
FROM syscolumns a LEFT OUTER JOIN
systypes b ON a.xusertype = b.xusertype INNER JOIN
sysobjects d ON a.id = d.id AND d.xtype = 'U' AND
d.name > 'dtproperties' LEFT OUTER JOIN
syscomments e ON a.cdefault = e.id LEFT OUTER JOIN
sysproperties g ON a.id = g.id AND a.colid = g.smallid LEFT OUTER JOIN
sysproperties f ON d.id = f.id AND f.smallid = 0
WHERE (d.name = '表名稱')
--2。SQL SERVER 2005
SELECT CASE WHEN EXISTS
(SELECT 1
FROM sysobjects
WHERE xtype = 'PK' AND parent_obj = a.id AND name IN
(SELECT name
FROM sysindexes
WHERE indid IN
(SELECT indid
FROM sysindexkeys
WHERE id = a.id AND colid = a.colid))) THEN '1' ELSE '0' END AS 'key', CASE WHEN COLUMNPROPERTY(a.id, a.name,
'IsIdentity') = 1 THEN '1' ELSE '0' END AS 'identity', a.name AS ColName, c.name AS TypeName, a.length AS 'byte', COLUMNPROPERTY(a.id, a.name,
'PRECISION') AS 'length', a.xscale, a.isnullable, ISNULL(e.text, '') AS 'default', ISNULL(p.value, '') AS 'comment'
FROM sys.syscolumns AS a INNER JOIN
sys.sysobjects AS b ON a.id = b.id INNER JOIN
sys.systypes AS c ON a.xtype = c.xtype LEFT OUTER JOIN
sys.syscomments AS e ON a.cdefault = e.id LEFT OUTER JOIN
sys.extended_properties AS p ON a.id = p.major_id AND a.colid = p.minor_id
WHERE (b.name = 'keyfactory') AND (c.status > '1')
--b.name = 'Keyfactory','Keyfactory'為你想要查找的數(shù)據(jù)表。

--2、SQL SERVER 2005
SELECT CASE WHEN EXISTS
(SELECT 1
FROM sysobjects
WHERE xtype = 'PK' AND parent_obj = a.id AND name IN
(SELECT name
FROM sysindexes
WHERE indid IN
(SELECT indid
FROM sysindexkeys
WHERE id = a.id AND colid = a.colid))) THEN '1' ELSE '0' END AS 'key', CASE WHEN COLUMNPROPERTY(a.id, a.name,
'IsIdentity') = 1 THEN '1' ELSE '0' END AS 'identity', a.name AS ColName, c.name AS TypeName, a.length AS 'byte', COLUMNPROPERTY(a.id, a.name,
'PRECISION') AS 'length', a.xscale, a.isnullable, ISNULL(e.text, '') AS 'default', ISNULL(p.value, '') AS 'comment'
FROM sys.syscolumns AS a INNER JOIN
sys.sysobjects AS b ON a.id = b.id INNER JOIN
sys.systypes AS c ON a.xtype = c.xtype LEFT OUTER JOIN
sys.syscomments AS e ON a.cdefault = e.id LEFT OUTER JOIN
sys.extended_properties AS p ON a.id = p.major_id AND a.colid = p.minor_id
WHERE (b.name = 'keyfactory') AND (c.status > '1')
--b.name = 'Keyfactory','Keyfactory'為你想要查找的數(shù)據(jù)表。

標(biāo)簽:江蘇 拉薩 昭通 重慶 呼和浩特 貴州 新鄉(xiāng) 上海

巨人網(wǎng)絡(luò)通訊聲明:本文標(biāo)題《獲取SQL Server表字段的各種屬性實(shí)例代碼》,本文關(guān)鍵詞  獲取,SQL,Server,表,字段,的,;如發(fā)現(xiàn)本文內(nèi)容存在版權(quán)問題,煩請(qǐng)?zhí)峁┫嚓P(guān)信息告之我們,我們將及時(shí)溝通與處理。本站內(nèi)容系統(tǒng)采集于網(wǎng)絡(luò),涉及言論、版權(quán)與本站無關(guān)。
  • 相關(guān)文章
  • 下面列出與本文章《獲取SQL Server表字段的各種屬性實(shí)例代碼》相關(guān)的同類信息!
  • 本頁(yè)收集關(guān)于獲取SQL Server表字段的各種屬性實(shí)例代碼的相關(guān)信息資訊供網(wǎng)民參考!
  • 企业400电话

    智能AI客服机器人
    15000

    在线订购

    合计11份范本:公司章程+合伙协议+出资协议+合作协议+股权转让协议+增资扩股协议+股权激励+股东会决议+董事会决议

    推薦文章
    主站蜘蛛池模板: 资溪县| 丰镇市| 古浪县| 东乡族自治县| 贺州市| 莆田市| 宜兰市| 汝南县| 西安市| 永靖县| 镇赉县| 德钦县| 朝阳区| 宁海县| 湖北省| 偃师市| 饶平县| 阿荣旗| 娱乐| 韶关市| 北碚区| 永嘉县| 沙坪坝区| 道孚县| 新邵县| 万山特区| 承德县| 青浦区| 巴里| 五指山市| 太保市| 开远市| 锦屏县| 那曲县| 吉安县| 合川市| 甘孜| 南和县| 旺苍县| 清苑县| 敦化市|