導讀:1建站知識本文介紹了“sql腳本查詢數據庫表,數據,結構,約束等操作的方法”，需要的朋友可以參考一下如何seo優化推廣網站網站seo優化課程。

1.查詢當前數據庫所有表

復制代碼 代碼如下:

SELECT O.object_id AS TableId, TableName=O.name , TableDesc= O.type FROM sys.columns C INNER JOIN sys.objects O ON C.[object_id]=O.[object_id] AND O.type='U' AND O.is_ms_shipped=0 INNER JOIN sys.types T ON C.user_seo網站優化軟件type_id=T.user_type_id LEFT JOIN sys.extended_properties PTB ON PTB.class=1 AND PTB.minor_id=0 AND C.[object_id]=PTB.major_idWHERE C.column_id=1 ORDER BY TableName

2.查詢當前表所有字段，數據，約束

復制代碼 代碼如下:

select tabName=O.NAME,columnLine=C.column_id,columnName=C.name,typeNum=T.name,typeLength=C.max_length,fState=ISNULL(G.value,N''),isAbleNull=CASE WHEN C.is_nullable=1 THEN N'√'ELSE N'' END,defaultData=ISNULL(D.definition,N''),isIdentity=CASE WHEN C.is_identity=1 THEN N'√'ELSE N'' END,isPrimary=case when exists(SELECT 1 FROM sysobjects where xtype='PK' and parent_obj=c.[object_id] and name in ( SELECT name FROM sysindexes WHERE indid in( SELECT indid FROM sysindexkeys WHERE id = c.[object_id] AND colid=c.column_id))) then '√' else '' end,isForeign=case when exists(select * from sysforeignkeys fk where C.[object_id]=FK.fkeyid AND C.column_id=FK.fkey)then '√' else '' end,TabForeignName=ISNULL(IDX.FKName,N''),OutNameCol=ISNULL(IDX.ns,N'')FROM sys.columns C INNER JOIN sys.objects OON C.[object_id]=O.[object_id] AND O.type='U' AND O.is_ms_shipped=0INNER JOIN sys.types T ON C.user_type_id=T.user_type_idleft JOIN sys.extended_properties G ON C.[object_id]=G.major_id and c.column_id=g.minor_idLEFT JOIN sys.default_co網站建設nstraints D ON C.[object_id]=D.parent_object_id AND C.column_id=D.parent_column_id AND C.default_object_id=D.[object_id]left join sysforeignkeys fk on C.[object_id]=FK.fkeyid and C.column_id=FK.fkey LEFT JOIN -- 索引及主鍵信息 ( SELECT IDX.fkeyid, IDX.fkey, FKName=o.name, ns=ss.name FROM sysforeignkeys IDX INNER JOIN sys.objects O ON IDX.rkeyid=O.[object_id] AND O.type='U' AND O.is_ms_shipped=0 left join syscolumns ss on IDX.rkeyid=ss.id and IDX.RKEY=SS.COLID )IDX ON C.[object_id]=IDX.fkeyid AND C.column_id=IDX.fkey

WHERE O.name=N'{0}' ------要查詢的表名ORDER BY O.name,C.column_id

3.字段

要加單引號varchar,char,nvarchar,nchar,text,ntext,datetime不需要加int,numeric,bit 不需要加

帶長度：[binary],[char],[decimal],[nchar],[numeric],[nvarchar],[varbinary][varchar]不用帶：[bigint],[bit],[datetime],[float],[image],[int],[xml],[timestamp],[tinyint], [uniqueidentifier],[money],[ntext],[real],[smalldatetime],[smallint],[smallmoney], [sql_網站seo優化軟件variant],[text]

相關如何seo優化推廣網站網站seo優化課程。

關鍵詞標簽: 結構 數據 腳本