Some useful system table in sql

Bageshkumarbagi
Posted by Bageshkumarbagi under Sql Server category on | Points: 40 | Views : 965
Hi,

select * from sys.syslanguages
select * from sys.configurations
select * from sys.certificates
select * from sys.crypt_properties
select * from sys.columns
select * from sys.database_files
select * from sys.database_permissions
select * from sys.database_role_members
select * from sys.databases
select * from sys.default_constraints
Select * from sys.endpoints
select * from sys.events
select * from sys.extended_procedures
select * from sys.foreign_key_columns
select * from sys.fulltext_document_types
select * from sys.fulltext_catalogs
select * from sys.fulltext_languages
select * from sys.fulltext_stoplists
select * from sys.filegroups
select * from sys.fulltext_stopwords
select * from sys.function_order_columns
select * from sys.http_endpoints
select * from sys.internal_tables
select * from sys.master_files
select * from sys.messages
select * from sys.objects
select * from sys.parameters
select * from sys.parameter_type_usages
select * from sys.partitions
select * from sys.procedures
select * from sys.remote_logins
select * from sys.server_events
select * from sys.servers
select * from sys.services
select * from sys.sql_dependencies
select * from sys.sql_logins
select * from sys.sysaltfiles
select * from sys.syscacheobjects
select * from sys.syscharsets
select * from sys.syscomments
select * from sys.sysconfigures
select * from sys.sysconstraints
select * from sys.sysdatabases
select * from sys.sysfilegroups
select * from sys.sysfulltextcatalogs
select * from sys.syslanguages
select * from sys.sysmessages
select * from sys.sysobjects
select * from sys.sysperfinfo
select * from sys.sysprocesses
select * from sys.sysreferences
select * from sys.system_objects
select * from sys.system_parameters
select * from sys.system_views
select * from sys.systypes
select * from sys.sysusers
select * from sys.table_types
select * from sys.tables
select * from sys.traces
select * from sys.triggers
select * from sys.views
select * from sys.xml_schema_types

Comments or Responses

Login to post response