Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select Table_Name, Column_name, data_type, is_Nullable
- from information_Schema.Columns
- SELECT K.TABLE_NAME,
- K.COLUMN_NAME,
- K.CONSTRAINT_NAME
- FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS C
- JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS K
- ON C.TABLE_NAME = K.TABLE_NAME
- AND C.CONSTRAINT_CATALOG = K.CONSTRAINT_CATALOG
- AND C.CONSTRAINT_SCHEMA = K.CONSTRAINT_SCHEMA
- AND C.CONSTRAINT_NAME = K.CONSTRAINT_NAME
- WHERE C.CONSTRAINT_TYPE = 'PRIMARY KEY'
- AND K.COLUMN_NAME = 'keycol';
- SELECT K.TABLE_NAME, C.CONSTRAINT_TYPE, K.COLUMN_NAME, K.CONSTRAINT_NAME
- FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS C
- JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS K
- ON C.TABLE_NAME = K.TABLE_NAME
- AND C.CONSTRAINT_CATALOG = K.CONSTRAINT_CATALOG
- AND C.CONSTRAINT_SCHEMA = K.CONSTRAINT_SCHEMA
- AND C.CONSTRAINT_NAME = K.CONSTRAINT_NAME
- WHERE C.CONSTRAINT_TYPE = 'PRIMARY KEY'
- ORDER BY K.TABLE_NAME, C.CONSTRAINT_TYPE, K.CONSTRAINT_NAME
Add Comment
Please, Sign In to add comment