TODO:
Have you ever wanted to find the table and column names referenced in a Foreign Key Constraint using T-SQL?
SOLUTION:
SELECT
OBJECT_NAME(fk.parent_object_id) TableName,
COL_NAME(fc.parent_object_id,fc.parent_column_id) ColName
FROM
sys.foreign_keys AS fk
INNER JOIN
sys.foreign_key_columns AS fkc
ON fk.OBJECT_ID = fkc.constraint_object_id
INNER JOIN
sys.tables t
ON t.OBJECT_ID = fkc.referenced_object_id
WHERE
OBJECT_NAME (fk.referenced_object_id) = 'YourTableGoesHere'
NOTES:
There are no notes on this topic.
TODO:
Have you ever wanted to drop a column to an existing SQL Server Table using T-SQL?
SOLUTION:
ALTER TABLE Customer DROP COLUMN FavoriteColor
NOTES:
There are no notes on this topic
TODO:
Have you ever wanted to add a column to an existing SQL Server Table using T-SQL?
SOLUTION:
ALTER TABLE Customer ADD FavoriteColor VARCHAR(20)
NOTES:
There are no notes on this topic
TODO:
Have you ever wanted to get a list of all of the columns in a database table, and their details, ordered by name?
SOLUTION:
SELECT
ORDINAL_POSITION
,COLUMN_NAME
,DATA_TYPE
,ISNULL(CONVERT(varchar,CHARACTER_MAXIMUM_LENGTH),'')
,IS_NULLABLE
,ISNULL(COLUMN_DEFAULT,'')
FROM
INFORMATION_SCHEMA.COLUMNS
WHERE
TABLE_NAME = 'tbl_name_here'
ORDER BY
COLUMN_NAME ASC;
NOTES:
No notes on this topic.