SQL query table field length, name, type, stored procedure creation and modification time

Gets the modification time of the stored procedure and the creation time of the query

--Table select * from sysobjects where id=object_id (N ' table name ') and xtype= ' U '  --table structure   select * from syscolumns where id=obje ct_id (N ' table name ')     --Stored procedure   

Query last Modified time

--Stored procedure select Name,modify_date from sys.all_objects where type= ' P ' ORDER by modify_date desc--trigger Select Name,modify_date From sys.all_objects where type= ' TR ' ORDER by modify_date desc-Table SELECT * from sys.all_objects where type= ' u ' ORDER by M Odify_date desc

SQL queries all fields, types, and lengths below a table

WHERE table_name = ' TableName '

--Modify the permissions of all tables to the permissions of the DBO

exec sp_msforeachtable ' exec sp_changeobjectowner '? ', ' dbo '

SQL query table field length, name, type, stored procedure creation and modification time