SQLServer 表创建日期查询

如何使用 SQL 查询获取 MSSQL 表的创建日期？
我在物理上看不到任何表，但是我可以查询那个特定的表。

202907 次浏览

小开

SELECT create_date
FROM sys.tables
WHERE name='YourTableName'

小开

最佳答案

For 2005 up, you can use

SELECT
[name]
,create_date
,modify_date
FROM
sys.tables

I think for 2000, you need to have enabled auditing.

小开

For SQL Server 2005 upwards:

SELECT [name] AS [TableName], [create_date] AS [CreatedDate] FROM sys.tables

For SQL Server 2000 upwards:

SELECT so.[name] AS [TableName], so.[crdate] AS [CreatedDate]
FROM INFORMATION_SCHEMA.TABLES AS it, sysobjects AS so
WHERE it.[TABLE_NAME] = so.[name]

小开

For SQL Server 2000:

SELECT   su.name,so.name,so.crdate,*
FROM     sysobjects so JOIN sysusers su
ON       so.uid = su.uid
WHERE    xtype='U'
ORDER BY so.name

小开

In case you also want Schema:

SELECT CONCAT(ic.TABLE_SCHEMA, '.', st.name) as TableName
,st.create_date
,st.modify_date


FROM sys.tables st


JOIN INFORMATION_SCHEMA.COLUMNS ic ON ic.TABLE_NAME = st.name


GROUP BY ic.TABLE_SCHEMA, st.name, st.create_date, st.modify_date


ORDER BY st.create_date