[SQL] MSSQL 명령어 모음
▒▒▒ Database Name ▒▒▒
SELECT name FROM master.dbo.sysdatabases WHERE HAS_DBACCESS(name) = 1
▒▒▒ Table Name ▒▒▒
SELECT name FROM 데이타베이스네임.dbo.sysobjects WHERE xtype='U' AND status > 0
▒▒▒ Table Schema ▒▒▒
EXEC SP_COLUMNS '테이블이름'
sp_help 'tablename'
SELECT name FROM master.dbo.sysdatabases WHERE HAS_DBACCESS(name) = 1
▒▒▒ Table Name ▒▒▒
SELECT name FROM 데이타베이스네임.dbo.sysobjects WHERE xtype='U' AND status > 0
▒▒▒ Table Schema ▒▒▒
EXEC SP_COLUMNS '테이블이름'
sp_help 'tablename'
댓글