キーやら型やらぱぱっと確認したいときに。
- 列情報の取得
sample1.sql
USE database
GO
EXEC sp_columns @table_name = N'table'
- プライマルキーの取得
sample2.sql
USE database
GO
EXEC sp_pkeys @table_name = N'table'
詳しくはこのあたりを。
More than 5 years have passed since last update.
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme