SQL Server 的系統資料表

SELECT name FROM sysobjects WHERE type = 'P'

SELECT * FROM sysobjects WHERE type='U'

SELECT * FROM sysobjects WHERE type='V'

select * from information_schema.parameters where specific_name='SP_ADD_PubDoorAuthNTIT'

select * from sys.parameters