SQL SERVER 2005 CHEAT SHEET

GO
SELECT f.name AS ForeignKey,
OBJECT_NAME(f.parent_object_id) AS TableName,
COL_NAME(fc.parent_object_id, fc.parent_column_id) AS ColumnName,
OBJECT_NAME (f.referenced_object_id) AS ReferenceTableName,
COL_NAME(fc.referenced_object_id, fc.referenced_column_id) AS ReferenceColumnName
FROM sys.foreign_keys AS f
INNER JOIN sys.foreign_key_columns AS fc
ON f.object_id = fc.constraint_object_id


-- SELECT * FROM INFORMATION_SCHEMA.TABLES


-- select all the columns from the SomeTable_tb table
-- SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'SomeTable_tb'
SELECT COLUMN_NAME , DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'SomeTable_tb'
SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'SomeTable_tb'
-- SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'SomeTable_tb'

-- SELECT * FROM sys.tables

-- used to gather statistics stored in memory but not persistent on disk such as thread information, memory usage, and connection details
-- SELECT * FROM sys.dm_exec_query_stats

-- EXEC sys.sp_columns 'SomeTable_tb'

-- SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLUMN_DEFAULT
-- FROM POC.INFORMATION_SCHEMA.COLUMNS
-- WHERE TABLE_NAME = N'SomeTable_tb';
-- SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'SomeTable_tb'