sqlcmd -S サーバー名 -U ユーザー名 -P パスワード -d データベース名 -Y20 -y 12 :help :out stdout :out hoge.txt set showplan_all on rollback go BEGIN TRANSACTION go select object_id, name from sys.synonyms order by name select object_id, nam…

SQL Server 2008 R2 (SP1) select coalesce(cast(i1.key_ordinal as char(2)), '') as PK, coalesce(cast(i2.key_ordinal as char(2)), '') as UQ, y1.name, c1.max_length, c1.precision, c1.scale, case when c1.is_nullable = 0 then 'NOT NULL' else '' …