Embedded Files
Check
Check
To describe table structure...
exec sp_columns mytable
exec sp_help 'myschema.mytable'
SELECT *
FROM information_schema.columns
WHERE table_name = 'mytable'
ORDER BY ordinal_position
If you have the First Responder kit installed...
exec sp_blitzindex @tablename='mytable'
CREATE TABLE
CREATE TABLE
TODO
ADD COLUMN
ADD COLUMN
TODO
DROP COLUMN
DROP COLUMN
ALTER TABLE mytable
DROP COLUMN mycolumn;
Note that the DROP COLUMN will fail if there are relational dependencies on it (e.g. you might have created a CONSTRAINT that references the column).
Ledger Tables
Ledger Tables
Announced at MS Build 2021. Based on Blockchain
Append only Ledger Tables
Updateable Ledger Tables
Bibliography
Bibliography
https://stackoverflow.com/questions/319354/what-is-the-equivalent-of-describe-table-in-sql-server
ALTER COLUMNhttps://stackoverflow.com/questions/25974271/will-increasing-the-precision-of-a-column-with-alter-affect-database-performance
DROP COLUMNhttps://www.sqlservertutorial.net/sql-server-basics/sql-server-alter-table-drop-column/
Ledger Tableshttps://www.avanade.com/en/blogs/techs-and-specs/azure/blockchain-sql-server-ledger-tableshttps://github.com/Avanade/emtech-distributed-data/blob/main/docs/sql-ledger-usecase.md
Blockchainhttps://benjaminsky.medium.com/blockchain-by-example-in-sql-server-8376b410128
ALTER COLUMNhttps://stackoverflow.com/questions/25974271/will-increasing-the-precision-of-a-column-with-alter-affect-database-performance
DROP COLUMNhttps://www.sqlservertutorial.net/sql-server-basics/sql-server-alter-table-drop-column/
Ledger Tableshttps://www.avanade.com/en/blogs/techs-and-specs/azure/blockchain-sql-server-ledger-tableshttps://github.com/Avanade/emtech-distributed-data/blob/main/docs/sql-ledger-usecase.md
Blockchainhttps://benjaminsky.medium.com/blockchain-by-example-in-sql-server-8376b410128
Page updated
Google Sites
Report abuse