MSSQL Tables

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

TODO

ADD COLUMN

TODO

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

Announced at MS Build 2021. Based on Blockchain

Bibliography