T-SQL magic

How to get indexes of current database?

select * from sys.indexes

How to get replication articles?

SELECT 
  msp.publication AS PublicationName,
  msa.publisher_db AS DatabaseName,
  msa.article AS ArticleName,
  msa.source_owner AS SchemaName,
  msa.source_object AS TableName
FROM distribution.dbo.MSarticles msa
JOIN distribution.dbo.MSpublications msp ON msa.publication_id = msp.publication_id
ORDER BY 
  msp.publication, 
  msa.article

select * from syspublications
select * from sysarticles where pubid = 3

• More info mation get get replication related table.
• Replication infomation
• Replication stored procedure

Useful replication stored procedure.

exec sp_dropsubscription
    @publication='**-Publication',
    @article= N'all',
    @subscriber = 'WIN-VPE**FSH8IJ'

exec sp_droppublication
    @publication='**-Publication'

exec sp_removedbreplication @dbname='**-local' 

How to close connect and drop db in sql server?

alter database [dbname] set SINGLE_USER with rollback immediate
drop database [dbname]

Other collections

• SqlServer important queries